Dataset statistics
| Number of variables | 30 |
|---|---|
| Number of observations | 1563215 |
| Missing cells | 1827272 |
| Missing cells (%) | 3.9% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 357.8 MiB |
| Average record size in memory | 240.0 B |
Variable types
| Numeric | 11 |
|---|---|
| Categorical | 18 |
| Boolean | 1 |
WORK GROUP has a high cardinality: 146 distinct values | High cardinality |
REQUEST TYPE has a high cardinality: 1236 distinct values | High cardinality |
CATEGORY has a high cardinality: 84 distinct values | High cardinality |
TYPE has a high cardinality: 295 distinct values | High cardinality |
DETAIL has a high cardinality: 574 distinct values | High cardinality |
CREATION DATE has a high cardinality: 5229 distinct values | High cardinality |
CREATION TIME has a high cardinality: 1440 distinct values | High cardinality |
CLOSED DATE has a high cardinality: 4995 distinct values | High cardinality |
STREET ADDRESS has a high cardinality: 277728 distinct values | High cardinality |
ADDRESS WITH GEOCODE has a high cardinality: 307249 distinct values | High cardinality |
NEIGHBORHOOD has a high cardinality: 250 distinct values | High cardinality |
CASE URL has a high cardinality: 1563215 distinct values | High cardinality |
SOURCE is highly imbalanced (72.5%) | Imbalance |
DEPARTMENT is highly imbalanced (55.9%) | Imbalance |
STATUS is highly imbalanced (94.2%) | Imbalance |
COUNTY is highly imbalanced (74.4%) | Imbalance |
CLOSED MONTH has 26515 (1.7%) missing values | Missing |
CLOSED YEAR has 26515 (1.7%) missing values | Missing |
DAYS TO CLOSE has 26515 (1.7%) missing values | Missing |
NEIGHBORHOOD has 46106 (2.9%) missing values | Missing |
COUNTY has 66959 (4.3%) missing values | Missing |
COUNCIL DISTRICT has 35242 (2.3%) missing values | Missing |
POLICE DISTRICT has 35265 (2.3%) missing values | Missing |
30-60-90 Days Open Window has 1550513 (99.2%) missing values | Missing |
ZIP CODE is highly skewed (γ1 = -832.06849) | Skewed |
PARCEL ID NO is highly skewed (γ1 = 250.9088658) | Skewed |
CASE URL is uniformly distributed | Uniform |
CASE ID has unique values | Unique |
CASE URL has unique values | Unique |
DAYS TO CLOSE has 150614 (9.6%) zeros | Zeros |
PARCEL ID NO has 35266 (2.3%) zeros | Zeros |
Reproduction
| Analysis started | 2023-02-25 15:09:55.053730 |
|---|---|
| Analysis finished | 2023-02-25 15:12:13.662627 |
| Duration | 2 minutes and 18.61 seconds |
| Software version | pandas-profiling v3.6.6 |
| Download configuration | config.json |
CASE ID
Real number (ℝ)
| Distinct | 1563215 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.0140133 × 109 |
| Minimum | 2.006 × 109 |
|---|---|
| Maximum | 2.0210337 × 109 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 11.9 MiB |
Quantile statistics
| Minimum | 2.006 × 109 |
|---|---|
| 5-th percentile | 2.0071832 × 109 |
| Q1 | 2.0101856 × 109 |
| median | 2.0140975 × 109 |
| Q3 | 2.0180632 × 109 |
| 95-th percentile | 2.0200896 × 109 |
| Maximum | 2.0210337 × 109 |
| Range | 15033684 |
| Interquartile range (IQR) | 7877594 |
Descriptive statistics
| Standard deviation | 4222588.7 |
|---|---|
| Coefficient of variation (CV) | 0.0020966042 |
| Kurtosis | -1.3391166 |
| Mean | 2.0140133 × 109 |
| Median Absolute Deviation (MAD) | 3950638 |
| Skewness | -0.072037995 |
| Sum | 3.1483358 × 1015 |
| Variance | 1.7830256 × 1013 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2019119972 | 1 | < 0.1% |
| 2015045877 | 1 | < 0.1% |
| 2015040302 | 1 | < 0.1% |
| 2015041682 | 1 | < 0.1% |
| 2015049038 | 1 | < 0.1% |
| 2015034811 | 1 | < 0.1% |
| 2015041579 | 1 | < 0.1% |
| 2015042453 | 1 | < 0.1% |
| 2015052481 | 1 | < 0.1% |
| 2015043953 | 1 | < 0.1% |
| Other values (1563205) | 1563205 |
| Value | Count | Frequency (%) |
| 2006000002 | 1 | |
| 2006000004 | 1 | |
| 2007000001 | 1 | |
| 2007000005 | 1 | |
| 2007000009 | 1 | |
| 2007000010 | 1 | |
| 2007000012 | 1 | |
| 2007000013 | 1 | |
| 2007000014 | 1 | |
| 2007000015 | 1 |
| Value | Count | Frequency (%) |
| 2021033686 | 1 | |
| 2021033407 | 1 | |
| 2021033233 | 1 | |
| 2021033140 | 1 | |
| 2021032869 | 1 | |
| 2021032828 | 1 | |
| 2021032612 | 1 | |
| 2021032575 | 1 | |
| 2021032525 | 1 | |
| 2021032480 | 1 |
SOURCE
Categorical
| Distinct | 21 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 67 |
| Missing (%) | < 0.1% |
| Memory size | 11.9 MiB |
| PHONE | |
|---|---|
| WEB | |
| 80585 | |
| SYS | 19226 |
| INSPE | 14690 |
| Other values (16) | 32690 |
Length
| Max length | 5 |
|---|---|
| Median length | 5 |
| Mean length | 4.677877 |
| Min length | 3 |
Characters and Unicode
| Total characters | 7312214 |
|---|---|
| Distinct characters | 22 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | PHONE |
|---|---|
| 2nd row | WEB |
| 3rd row | PHONE |
| 4th row | PHONE |
| 5th row | WEB |
Common Values
| Value | Count | Frequency (%) |
| PHONE | 1204236 | |
| WEB | 211721 | 13.5% |
| 80585 | 5.2% | |
| SYS | 19226 | 1.2% |
| INSPE | 14690 | 0.9% |
| BOT | 13396 | 0.9% |
| TWIR | 8311 | 0.5% |
| VOICE | 6021 | 0.4% |
| WALK | 1792 | 0.1% |
| FAX | 1538 | 0.1% |
| Other values (11) | 1632 | 0.1% |
Length
| Value | Count | Frequency (%) |
| phone | 1204236 | |
| web | 211721 | 13.5% |
| 80585 | 5.2% | |
| sys | 19226 | 1.2% |
| inspe | 14690 | 0.9% |
| bot | 13396 | 0.9% |
| twir | 8311 | 0.5% |
| voice | 6021 | 0.4% |
| walk | 1792 | 0.1% |
| fax | 1538 | 0.1% |
| Other values (11) | 1632 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 1518427 | |
| O | 1223712 | |
| P | 1219913 | |
| N | 1218950 | |
| H | 1204260 | |
| B | 225129 | 3.1% |
| W | 221824 | 3.0% |
| I | 110312 | 1.5% |
| A | 84238 | 1.2% |
| L | 82700 | 1.1% |
| Other values (12) | 202749 | 2.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 7312214 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 1518427 | |
| O | 1223712 | |
| P | 1219913 | |
| N | 1218950 | |
| H | 1204260 | |
| B | 225129 | 3.1% |
| W | 221824 | 3.0% |
| I | 110312 | 1.5% |
| A | 84238 | 1.2% |
| L | 82700 | 1.1% |
| Other values (12) | 202749 | 2.8% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 7312214 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| E | 1518427 | |
| O | 1223712 | |
| P | 1219913 | |
| N | 1218950 | |
| H | 1204260 | |
| B | 225129 | 3.1% |
| W | 221824 | 3.0% |
| I | 110312 | 1.5% |
| A | 84238 | 1.2% |
| L | 82700 | 1.1% |
| Other values (12) | 202749 | 2.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 7312214 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| E | 1518427 | |
| O | 1223712 | |
| P | 1219913 | |
| N | 1218950 | |
| H | 1204260 | |
| B | 225129 | 3.1% |
| W | 221824 | 3.0% |
| I | 110312 | 1.5% |
| A | 84238 | 1.2% |
| L | 82700 | 1.1% |
| Other values (12) | 202749 | 2.8% |
DEPARTMENT
Categorical
| Distinct | 27 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 11.9 MiB |
| NHS | |
|---|---|
| Public Works | |
| Water Services | |
| Parks and Rec | |
| Health | 39543 |
| Other values (22) |
Length
| Max length | 35 |
|---|---|
| Median length | 3 |
| Mean length | 7.6318446 |
| Min length | 2 |
Characters and Unicode
| Total characters | 11930214 |
|---|---|
| Distinct characters | 40 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | NHS |
|---|---|
| 2nd row | Public Works |
| 3rd row | NHS |
| 4th row | NHS |
| 5th row | Parks and Rec |
Common Values
| Value | Count | Frequency (%) |
| NHS | 783094 | |
| Public Works | 353787 | |
| Water Services | 216852 | 13.9% |
| Parks and Rec | 87954 | 5.6% |
| Health | 39543 | 2.5% |
| KCPD | 36369 | 2.3% |
| City Managers Office | 13098 | 0.8% |
| City Planning and Development | 12575 | 0.8% |
| Northland | 8591 | 0.5% |
| NCS | 6391 | 0.4% |
| Other values (17) | 4961 | 0.3% |
Length
| Value | Count | Frequency (%) |
| nhs | 783094 | |
| public | 353787 | |
| works | 353787 | |
| water | 216852 | 9.1% |
| services | 216852 | 9.1% |
| and | 100588 | 4.2% |
| parks | 88826 | 3.7% |
| rec | 88815 | 3.7% |
| health | 39543 | 1.7% |
| kcpd | 36369 | 1.5% |
| Other values (32) | 98741 | 4.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| S | 1007164 | 8.4% |
| r | 900261 | 7.5% |
| e | 847896 | 7.1% |
| H | 822980 | 6.9% |
| 814039 | 6.8% | |
| N | 798111 | 6.7% |
| c | 675143 | 5.7% |
| s | 672981 | 5.6% |
| i | 626675 | 5.3% |
| W | 570639 | 4.8% |
| Other values (30) | 4194325 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 7151431 | |
| Uppercase Letter | 3963872 | |
| Space Separator | 814039 | 6.8% |
| Other Punctuation | 872 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| r | 900261 | |
| e | 847896 | |
| c | 675143 | |
| s | 672981 | |
| i | 626675 | |
| a | 496002 | 6.9% |
| k | 442615 | 6.2% |
| l | 427997 | 6.0% |
| o | 376777 | 5.3% |
| u | 355543 | 5.0% |
| Other values (11) | 1329541 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 1007164 | |
| H | 822980 | |
| N | 798111 | |
| W | 570639 | |
| P | 491557 | |
| R | 88827 | 2.2% |
| C | 69282 | 1.7% |
| D | 49286 | 1.2% |
| K | 36369 | 0.9% |
| M | 13514 | 0.3% |
| Other values (7) | 16143 | 0.4% |
Space Separator
| Value | Count | Frequency (%) |
| 814039 |
Other Punctuation
| Value | Count | Frequency (%) |
| & | 872 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 11115303 | |
| Common | 814911 | 6.8% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| S | 1007164 | 9.1% |
| r | 900261 | 8.1% |
| e | 847896 | 7.6% |
| H | 822980 | 7.4% |
| N | 798111 | 7.2% |
| c | 675143 | 6.1% |
| s | 672981 | 6.1% |
| i | 626675 | 5.6% |
| W | 570639 | 5.1% |
| a | 496002 | 4.5% |
| Other values (28) | 3697451 |
Common
| Value | Count | Frequency (%) |
| 814039 | ||
| & | 872 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 11930214 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| S | 1007164 | 8.4% |
| r | 900261 | 7.5% |
| e | 847896 | 7.1% |
| H | 822980 | 6.9% |
| 814039 | 6.8% | |
| N | 798111 | 6.7% |
| c | 675143 | 5.7% |
| s | 672981 | 5.6% |
| i | 626675 | 5.3% |
| W | 570639 | 4.8% |
| Other values (30) | 4194325 |
WORK GROUP
Categorical
| Distinct | 146 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 11.9 MiB |
| NHS-Neighborhood Preservation- | |
|---|---|
| NHS-Solid Waste- | |
| NHS-Animal Health and Safety- | |
| Public Works-Solid Waste- | |
| Water Services-Meter and Field Services- | |
| Other values (141) |
Length
| Max length | 50 |
|---|---|
| Median length | 47 |
| Mean length | 31.048004 |
| Min length | 6 |
Characters and Unicode
| Total characters | 48534706 |
|---|---|
| Distinct characters | 53 |
| Distinct categories | 6 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 5 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | NHS-Dangerous Buildings- |
|---|---|
| 2nd row | Public Works-Street and Traffic-District 1 |
| 3rd row | NHS-Dangerous Buildings- |
| 4th row | NHS-Neighborhood Preservation- |
| 5th row | Parks and Rec-Central Region- |
Common Values
| Value | Count | Frequency (%) |
| NHS-Neighborhood Preservation- | 286049 | |
| NHS-Solid Waste- | 238286 | |
| NHS-Animal Health and Safety- | 136453 | 8.7% |
| Public Works-Solid Waste- | 99384 | 6.4% |
| Water Services-Meter and Field Services- | 88432 | 5.7% |
| Parks and Rec-Landscape Services-Forestry | 65660 | 4.2% |
| NHS-Solid Waste-Administration | 44450 | 2.8% |
| Public Works-Street and Traffic-District 3 | 40955 | 2.6% |
| Water Services-Line Maintenance-Wastewater | 39641 | 2.5% |
| Public Works-Street and Traffic-Streetlights | 38108 | 2.4% |
| Other values (136) | 485797 |
Length
| Value | Count | Frequency (%) |
| and | 497876 | 10.5% |
| public | 353787 | 7.5% |
| waste | 337776 | 7.2% |
| nhs-neighborhood | 317500 | 6.7% |
| nhs-solid | 299322 | 6.3% |
| preservation | 286854 | 6.1% |
| water | 216852 | 4.6% |
| works-street | 159398 | 3.4% |
| health | 143813 | 3.0% |
| nhs-animal | 139749 | 3.0% |
| Other values (206) | 1968123 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 4530059 | 9.3% |
| i | 3300515 | 6.8% |
| r | 3283333 | 6.8% |
| a | 3180184 | 6.6% |
| 3157835 | 6.5% | |
| - | 3121076 | 6.4% |
| t | 2853937 | 5.9% |
| o | 2635467 | 5.4% |
| s | 2190723 | 4.5% |
| n | 2099413 | 4.3% |
| Other values (43) | 18182164 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 34166821 | |
| Uppercase Letter | 7973083 | 16.4% |
| Space Separator | 3157835 | 6.5% |
| Dash Punctuation | 3121076 | 6.4% |
| Decimal Number | 114274 | 0.2% |
| Other Punctuation | 1617 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 4530059 | |
| i | 3300515 | |
| r | 3283333 | |
| a | 3180184 | |
| t | 2853937 | |
| o | 2635467 | 7.7% |
| s | 2190723 | 6.4% |
| n | 2099413 | 6.1% |
| l | 1550002 | 4.5% |
| d | 1511973 | 4.4% |
| Other values (14) | 7031215 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 2058471 | |
| N | 1136393 | |
| W | 1020241 | |
| P | 1005647 | |
| H | 976676 | |
| C | 262046 | 3.3% |
| A | 220751 | 2.8% |
| M | 215408 | 2.7% |
| T | 213447 | 2.7% |
| L | 202835 | 2.5% |
| Other values (13) | 661168 | 8.3% |
Decimal Number
| Value | Count | Frequency (%) |
| 3 | 50862 | |
| 1 | 39053 | |
| 2 | 24359 |
Space Separator
| Value | Count | Frequency (%) |
| 3157835 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 3121076 |
Other Punctuation
| Value | Count | Frequency (%) |
| & | 1617 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 42139904 | |
| Common | 6394802 | 13.2% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 4530059 | 10.8% |
| i | 3300515 | 7.8% |
| r | 3283333 | 7.8% |
| a | 3180184 | 7.5% |
| t | 2853937 | 6.8% |
| o | 2635467 | 6.3% |
| s | 2190723 | 5.2% |
| n | 2099413 | 5.0% |
| S | 2058471 | 4.9% |
| l | 1550002 | 3.7% |
| Other values (37) | 14457800 |
Common
| Value | Count | Frequency (%) |
| 3157835 | ||
| - | 3121076 | |
| 3 | 50862 | 0.8% |
| 1 | 39053 | 0.6% |
| 2 | 24359 | 0.4% |
| & | 1617 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 48534706 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 4530059 | 9.3% |
| i | 3300515 | 6.8% |
| r | 3283333 | 6.8% |
| a | 3180184 | 6.6% |
| 3157835 | 6.5% | |
| - | 3121076 | 6.4% |
| t | 2853937 | 5.9% |
| o | 2635467 | 5.4% |
| s | 2190723 | 4.5% |
| n | 2099413 | 4.3% |
| Other values (43) | 18182164 |
REQUEST TYPE
Categorical
| Distinct | 1236 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 11.9 MiB |
| Property Violations | |
|---|---|
| Nuisance Violations | 41386 |
| Animal Control | 34613 |
| Water Leak or Pressure Problem | 33054 |
| Dead Animal Pick-up | 28712 |
| Other values (1231) |
Length
| Max length | 80 |
|---|---|
| Median length | 67 |
| Mean length | 32.553566 |
| Min length | 7 |
Characters and Unicode
| Total characters | 50888223 |
|---|---|
| Distinct characters | 73 |
| Distinct categories | 10 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 2 ? |
Unique
| Unique | 70 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Prop/Build/Construct-Dangerous Building-On list |
|---|---|
| 2nd row | Streets / Roadways / Alleys-Crack-District 1 |
| 3rd row | Prop/Build/Construct-Dangerous Building-On list |
| 4th row | Property Violations |
| 5th row | Parks & Recreation-Park Maintenance-Central |
Common Values
| Value | Count | Frequency (%) |
| Property Violations | 224533 | 14.4% |
| Nuisance Violations | 41386 | 2.6% |
| Animal Control | 34613 | 2.2% |
| Water Leak or Pressure Problem | 33054 | 2.1% |
| Dead Animal Pick-up | 28712 | 1.8% |
| Trash / Recycling-Trash Collection-Missed by Contractor South | 28476 | 1.8% |
| Solid Waste Customer Service | 23091 | 1.5% |
| Trash / Recycling-Trash Collection-Missed by Contractor North | 22272 | 1.4% |
| Streets / Roadways / Alleys-Pothole-District 3 | 22042 | 1.4% |
| Abandoned Vehicle | 19023 | 1.2% |
| Other values (1226) | 1086013 |
Length
| Value | Count | Frequency (%) |
| 765661 | 11.3% | |
| violations | 297534 | 4.4% |
| property | 272148 | 4.0% |
| trash | 239752 | 3.5% |
| by | 172991 | 2.5% |
| animal | 132435 | 1.9% |
| water | 126206 | 1.9% |
| or | 121976 | 1.8% |
| contractor | 119869 | 1.8% |
| missed | 101448 | 1.5% |
| Other values (1269) | 4453170 |
Most occurring characters
| Value | Count | Frequency (%) |
| 5240289 | 10.3% | |
| e | 4342352 | 8.5% |
| r | 3473307 | 6.8% |
| t | 3409110 | 6.7% |
| i | 3178178 | 6.2% |
| o | 2898784 | 5.7% |
| a | 2854112 | 5.6% |
| n | 2631165 | 5.2% |
| s | 2510366 | 4.9% |
| l | 1989500 | 3.9% |
| Other values (63) | 18361060 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 36579696 | |
| Uppercase Letter | 6621246 | 13.0% |
| Space Separator | 5240289 | 10.3% |
| Dash Punctuation | 1431477 | 2.8% |
| Other Punctuation | 713489 | 1.4% |
| Decimal Number | 213756 | 0.4% |
| Open Punctuation | 43303 | 0.1% |
| Close Punctuation | 42842 | 0.1% |
| Math Symbol | 2038 | < 0.1% |
| Initial Punctuation | 87 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 4342352 | |
| r | 3473307 | |
| t | 3409110 | |
| i | 3178178 | |
| o | 2898784 | 7.9% |
| a | 2854112 | 7.8% |
| n | 2631165 | 7.2% |
| s | 2510366 | 6.9% |
| l | 1989500 | 5.4% |
| c | 1480628 | 4.0% |
| Other values (16) | 7812194 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 843642 | |
| P | 822834 | |
| R | 587903 | |
| C | 583764 | |
| T | 552829 | 8.3% |
| A | 472383 | 7.1% |
| V | 373397 | 5.6% |
| M | 356041 | 5.4% |
| W | 323551 | 4.9% |
| D | 309053 | 4.7% |
| Other values (15) | 1395849 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 45085 | |
| 3 | 42714 | |
| 2 | 42378 | |
| 7 | 28431 | |
| 4 | 27627 | |
| 0 | 14649 | 6.9% |
| 5 | 4530 | 2.1% |
| 6 | 2921 | 1.4% |
| 8 | 2813 | 1.3% |
| 9 | 2608 | 1.2% |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 702783 | |
| & | 6604 | 0.9% |
| , | 3964 | 0.6% |
| ' | 108 | < 0.1% |
| . | 30 | < 0.1% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 1423974 | |
| – | 7503 | 0.5% |
Space Separator
| Value | Count | Frequency (%) |
| 5240289 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 43303 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 42842 |
Math Symbol
| Value | Count | Frequency (%) |
| + | 2038 |
Initial Punctuation
| Value | Count | Frequency (%) |
| ‘ | 87 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 43200942 | |
| Common | 7687281 | 15.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 4342352 | 10.1% |
| r | 3473307 | 8.0% |
| t | 3409110 | 7.9% |
| i | 3178178 | 7.4% |
| o | 2898784 | 6.7% |
| a | 2854112 | 6.6% |
| n | 2631165 | 6.1% |
| s | 2510366 | 5.8% |
| l | 1989500 | 4.6% |
| c | 1480628 | 3.4% |
| Other values (41) | 14433440 |
Common
| Value | Count | Frequency (%) |
| 5240289 | ||
| - | 1423974 | 18.5% |
| / | 702783 | 9.1% |
| 1 | 45085 | 0.6% |
| ( | 43303 | 0.6% |
| ) | 42842 | 0.6% |
| 3 | 42714 | 0.6% |
| 2 | 42378 | 0.6% |
| 7 | 28431 | 0.4% |
| 4 | 27627 | 0.4% |
| Other values (12) | 47855 | 0.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 50880633 | |
| Punctuation | 7590 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 5240289 | 10.3% | |
| e | 4342352 | 8.5% |
| r | 3473307 | 6.8% |
| t | 3409110 | 6.7% |
| i | 3178178 | 6.2% |
| o | 2898784 | 5.7% |
| a | 2854112 | 5.6% |
| n | 2631165 | 5.2% |
| s | 2510366 | 4.9% |
| l | 1989500 | 3.9% |
| Other values (61) | 18353470 |
Punctuation
| Value | Count | Frequency (%) |
| – | 7503 | |
| ‘ | 87 | 1.1% |
CATEGORY
Categorical
| Distinct | 84 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 11.9 MiB |
| Trash / Recycling | |
|---|---|
| Trash | |
| Property Violations | |
| Animal | |
| Streets / Roadways / Alleys | 74919 |
| Other values (79) |
Length
| Max length | 35 |
|---|---|
| Median length | 30 |
| Mean length | 13.94984 |
| Min length | 3 |
Characters and Unicode
| Total characters | 21806599 |
|---|---|
| Distinct characters | 48 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 3 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Property / Buildings / Construction |
|---|---|
| 2nd row | Streets / Roadways / Alleys |
| 3rd row | Property / Buildings / Construction |
| 4th row | Property / Buildings / Construction |
| 5th row | Parks & Recreation |
Common Values
| Value | Count | Frequency (%) |
| Trash / Recycling | 205683 | 13.2% |
| Trash | 168125 | 10.8% |
| Property Violations | 134094 | 8.6% |
| Animal | 98921 | 6.3% |
| Streets / Roadways / Alleys | 74919 | 4.8% |
| Trees | 73966 | 4.7% |
| Animals / Pets | 73694 | 4.7% |
| Property / Buildings / Construction | 73234 | 4.7% |
| Water Leak | 71347 | 4.6% |
| Water | 56724 | 3.6% |
| Other values (74) | 532508 |
Length
| Value | Count | Frequency (%) |
| 777196 | ||
| trash | 373808 | 10.4% |
| property | 232185 | 6.5% |
| recycling | 205683 | 5.7% |
| violations | 199740 | 5.6% |
| water | 185164 | 5.2% |
| animal | 98921 | 2.8% |
| streets | 74919 | 2.1% |
| roadways | 74919 | 2.1% |
| alleys | 74919 | 2.1% |
| Other values (101) | 1295445 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2029684 | 9.3% | |
| e | 1770832 | 8.1% |
| r | 1514568 | 6.9% |
| i | 1482107 | 6.8% |
| s | 1453162 | 6.7% |
| a | 1415107 | 6.5% |
| t | 1330280 | 6.1% |
| n | 1154224 | 5.3% |
| o | 1090374 | 5.0% |
| l | 1026372 | 4.7% |
| Other values (38) | 7539889 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 16186973 | |
| Uppercase Letter | 2812746 | 12.9% |
| Space Separator | 2029684 | 9.3% |
| Other Punctuation | 777196 | 3.6% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 1770832 | |
| r | 1514568 | |
| i | 1482107 | |
| s | 1453162 | |
| a | 1415107 | |
| t | 1330280 | |
| n | 1154224 | 7.1% |
| o | 1090374 | 6.7% |
| l | 1026372 | 6.3% |
| c | 727972 | 4.5% |
| Other values (14) | 3221975 |
Uppercase Letter
| Value | Count | Frequency (%) |
| T | 457894 | |
| P | 421154 | |
| S | 333684 | |
| R | 290911 | |
| A | 276437 | |
| W | 261172 | |
| V | 248665 | |
| L | 119789 | 4.3% |
| B | 100690 | 3.6% |
| C | 97569 | 3.5% |
| Other values (11) | 204781 |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 719830 | |
| & | 57366 | 7.4% |
Space Separator
| Value | Count | Frequency (%) |
| 2029684 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 18999719 | |
| Common | 2806880 | 12.9% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 1770832 | 9.3% |
| r | 1514568 | 8.0% |
| i | 1482107 | 7.8% |
| s | 1453162 | 7.6% |
| a | 1415107 | 7.4% |
| t | 1330280 | 7.0% |
| n | 1154224 | 6.1% |
| o | 1090374 | 5.7% |
| l | 1026372 | 5.4% |
| c | 727972 | 3.8% |
| Other values (35) | 6034721 |
Common
| Value | Count | Frequency (%) |
| 2029684 | ||
| / | 719830 | 25.6% |
| & | 57366 | 2.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 21806599 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 2029684 | 9.3% | |
| e | 1770832 | 8.1% |
| r | 1514568 | 6.9% |
| i | 1482107 | 6.8% |
| s | 1453162 | 6.7% |
| a | 1415107 | 6.5% |
| t | 1330280 | 6.1% |
| n | 1154224 | 5.3% |
| o | 1090374 | 5.0% |
| l | 1026372 | 4.7% |
| Other values (38) | 7539889 |
TYPE
Categorical
| Distinct | 295 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 11.9 MiB |
| Private Property | |
|---|---|
| Trash Collection | 70001 |
| Property Maintenance | 56455 |
| Street | 48630 |
| Pothole | 39777 |
| Other values (290) |
Length
| Max length | 48 |
|---|---|
| Median length | 29 |
| Mean length | 11.899895 |
| Min length | 2 |
Characters and Unicode
| Total characters | 18602094 |
|---|---|
| Distinct characters | 69 |
| Distinct categories | 9 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 2 ? |
Unique
| Unique | 7 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Dangerous Building |
|---|---|
| 2nd row | Crack |
| 3rd row | Dangerous Building |
| 4th row | Property Maintenance |
| 5th row | Park Maintenance |
Common Values
| Value | Count | Frequency (%) |
| Private Property | 181843 | 11.6% |
| Trash Collection | 70001 | 4.5% |
| Property Maintenance | 56455 | 3.6% |
| Street | 48630 | 3.1% |
| Pothole | 39777 | 2.5% |
| Recycling | 38664 | 2.5% |
| Investigations | 36064 | 2.3% |
| Other | 34611 | 2.2% |
| Services | 31559 | 2.0% |
| Administration | 30418 | 1.9% |
| Other values (285) | 995193 |
Length
| Value | Count | Frequency (%) |
| property | 246467 | 9.1% |
| private | 213828 | 7.9% |
| 118647 | 4.4% | |
| street | 99068 | 3.7% |
| trash | 70159 | 2.6% |
| collection | 70001 | 2.6% |
| maintenance | 65340 | 2.4% |
| animal | 52113 | 1.9% |
| stray | 47867 | 1.8% |
| pothole | 39777 | 1.5% |
| Other values (343) | 1683117 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 1934335 | 10.4% |
| r | 1626910 | 8.7% |
| t | 1536231 | 8.3% |
| a | 1346391 | 7.2% |
| i | 1251603 | 6.7% |
| 1143169 | 6.1% | |
| n | 1133790 | 6.1% |
| o | 1009491 | 5.4% |
| l | 663892 | 3.6% |
| P | 578906 | 3.1% |
| Other values (59) | 6377376 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 14743571 | |
| Uppercase Letter | 2509188 | 13.5% |
| Space Separator | 1143169 | 6.1% |
| Other Punctuation | 125515 | 0.7% |
| Decimal Number | 54301 | 0.3% |
| Dash Punctuation | 13999 | 0.1% |
| Open Punctuation | 6102 | < 0.1% |
| Close Punctuation | 6102 | < 0.1% |
| Initial Punctuation | 147 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 1934335 | |
| r | 1626910 | |
| t | 1536231 | |
| a | 1346391 | |
| i | 1251603 | 8.5% |
| n | 1133790 | 7.7% |
| o | 1009491 | 6.8% |
| l | 663892 | 4.5% |
| c | 562616 | 3.8% |
| y | 499008 | 3.4% |
| Other values (16) | 3179304 |
Uppercase Letter
| Value | Count | Frequency (%) |
| P | 578906 | |
| S | 289650 | |
| C | 240537 | |
| R | 183614 | 7.3% |
| A | 162665 | 6.5% |
| B | 147822 | 5.9% |
| T | 145769 | 5.8% |
| D | 118884 | 4.7% |
| L | 109082 | 4.3% |
| M | 108032 | 4.3% |
| Other values (15) | 424227 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 14948 | |
| 2 | 11371 | |
| 0 | 8742 | |
| 3 | 3140 | 5.8% |
| 6 | 2923 | 5.4% |
| 8 | 2812 | 5.2% |
| 4 | 2647 | 4.9% |
| 7 | 2619 | 4.8% |
| 9 | 2608 | 4.8% |
| 5 | 2491 | 4.6% |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 116109 | |
| & | 9373 | 7.5% |
| . | 33 | < 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 1143169 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 13999 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 6102 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 6102 |
Initial Punctuation
| Value | Count | Frequency (%) |
| ‘ | 147 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 17252759 | |
| Common | 1349335 | 7.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 1934335 | 11.2% |
| r | 1626910 | 9.4% |
| t | 1536231 | 8.9% |
| a | 1346391 | 7.8% |
| i | 1251603 | 7.3% |
| n | 1133790 | 6.6% |
| o | 1009491 | 5.9% |
| l | 663892 | 3.8% |
| P | 578906 | 3.4% |
| c | 562616 | 3.3% |
| Other values (41) | 5608594 |
Common
| Value | Count | Frequency (%) |
| 1143169 | ||
| / | 116109 | 8.6% |
| 1 | 14948 | 1.1% |
| - | 13999 | 1.0% |
| 2 | 11371 | 0.8% |
| & | 9373 | 0.7% |
| 0 | 8742 | 0.6% |
| ( | 6102 | 0.5% |
| ) | 6102 | 0.5% |
| 3 | 3140 | 0.2% |
| Other values (8) | 16280 | 1.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 18601947 | |
| Punctuation | 147 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 1934335 | 10.4% |
| r | 1626910 | 8.7% |
| t | 1536231 | 8.3% |
| a | 1346391 | 7.2% |
| i | 1251603 | 6.7% |
| 1143169 | 6.1% | |
| n | 1133790 | 6.1% |
| o | 1009491 | 5.4% |
| l | 663892 | 3.6% |
| P | 578906 | 3.1% |
| Other values (58) | 6377229 |
Punctuation
| Value | Count | Frequency (%) |
| ‘ | 147 |
DETAIL
Categorical
| Distinct | 574 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 11.9 MiB |
| All | |
|---|---|
| Missed | 49518 |
| Missed by Contractor North | 39989 |
| Missed by Contractor South | 39955 |
| Non Emergency | 34611 |
| Other values (569) |
Length
| Max length | 48 |
|---|---|
| Median length | 31 |
| Mean length | 10.467135 |
| Min length | 3 |
Characters and Unicode
| Total characters | 16362382 |
|---|---|
| Distinct characters | 66 |
| Distinct categories | 10 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 2 ? |
Unique
| Unique | 36 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Standard |
|---|---|
| 2nd row | District 1 |
| 3rd row | Standard |
| 4th row | Other Property Issue |
| 5th row | Central |
Common Values
| Value | Count | Frequency (%) |
| All | 426673 | |
| Missed | 49518 | 3.2% |
| Missed by Contractor North | 39989 | 2.6% |
| Missed by Contractor South | 39955 | 2.6% |
| Non Emergency | 34611 | 2.2% |
| *Select one | 32305 | 2.1% |
| District 3 | 31905 | 2.0% |
| Dead | 30393 | 1.9% |
| Missed by City | 27268 | 1.7% |
| Other Property Issue | 26124 | 1.7% |
| Other values (564) | 824474 |
Length
| Value | Count | Frequency (%) |
| all | 428758 | 14.3% |
| missed | 172087 | 5.8% |
| 135089 | 4.5% | |
| by | 107464 | 3.6% |
| district | 107235 | 3.6% |
| contractor | 89601 | 3.0% |
| property | 70100 | 2.3% |
| south | 69653 | 2.3% |
| north | 60495 | 2.0% |
| one | 57947 | 1.9% |
| Other values (600) | 1693151 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 1505379 | 9.2% |
| 1428365 | 8.7% | |
| t | 1310932 | 8.0% |
| r | 1212748 | 7.4% |
| l | 1087247 | 6.6% |
| i | 896135 | 5.5% |
| o | 845654 | 5.2% |
| s | 787339 | 4.8% |
| n | 708151 | 4.3% |
| a | 643131 | 3.9% |
| Other values (56) | 5937301 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 11901213 | |
| Uppercase Letter | 2711940 | 16.6% |
| Space Separator | 1428365 | 8.7% |
| Dash Punctuation | 114893 | 0.7% |
| Other Punctuation | 108326 | 0.7% |
| Decimal Number | 78896 | 0.5% |
| Open Punctuation | 8339 | 0.1% |
| Close Punctuation | 8339 | 0.1% |
| Math Symbol | 2038 | < 0.1% |
| Initial Punctuation | 33 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 1505379 | |
| t | 1310932 | |
| r | 1212748 | |
| l | 1087247 | |
| i | 896135 | 7.5% |
| o | 845654 | 7.1% |
| s | 787339 | 6.6% |
| n | 708151 | 6.0% |
| a | 643131 | 5.4% |
| c | 431294 | 3.6% |
| Other values (16) | 2473203 |
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 510716 | |
| S | 295407 | |
| M | 234827 | |
| C | 234346 | |
| D | 189901 | 7.0% |
| P | 175668 | 6.5% |
| N | 159626 | 5.9% |
| L | 151890 | 5.6% |
| O | 134016 | 4.9% |
| T | 120206 | 4.4% |
| Other values (15) | 505337 |
Decimal Number
| Value | Count | Frequency (%) |
| 3 | 31985 | |
| 1 | 22084 | |
| 2 | 20851 | |
| 5 | 2038 | 2.6% |
| 4 | 1938 | 2.5% |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 62947 | |
| * | 45286 | |
| ' | 64 | 0.1% |
| . | 29 | < 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 1428365 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 114893 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 8339 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 8339 |
Math Symbol
| Value | Count | Frequency (%) |
| + | 2038 |
Initial Punctuation
| Value | Count | Frequency (%) |
| ‘ | 33 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 14613153 | |
| Common | 1749229 | 10.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 1505379 | 10.3% |
| t | 1310932 | 9.0% |
| r | 1212748 | 8.3% |
| l | 1087247 | 7.4% |
| i | 896135 | 6.1% |
| o | 845654 | 5.8% |
| s | 787339 | 5.4% |
| n | 708151 | 4.8% |
| a | 643131 | 4.4% |
| A | 510716 | 3.5% |
| Other values (41) | 5105721 |
Common
| Value | Count | Frequency (%) |
| 1428365 | ||
| - | 114893 | 6.6% |
| / | 62947 | 3.6% |
| * | 45286 | 2.6% |
| 3 | 31985 | 1.8% |
| 1 | 22084 | 1.3% |
| 2 | 20851 | 1.2% |
| ( | 8339 | 0.5% |
| ) | 8339 | 0.5% |
| 5 | 2038 | 0.1% |
| Other values (5) | 4102 | 0.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 16362349 | |
| Punctuation | 33 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 1505379 | 9.2% |
| 1428365 | 8.7% | |
| t | 1310932 | 8.0% |
| r | 1212748 | 7.4% |
| l | 1087247 | 6.6% |
| i | 896135 | 5.5% |
| o | 845654 | 5.2% |
| s | 787339 | 4.8% |
| n | 708151 | 4.3% |
| a | 643131 | 3.9% |
| Other values (55) | 5937268 |
Punctuation
| Value | Count | Frequency (%) |
| ‘ | 33 |
CREATION DATE
Categorical
| Distinct | 5229 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 11.9 MiB |
| 01/22/2019 | 2313 |
|---|---|
| 01/24/2019 | 2130 |
| 01/23/2019 | 1816 |
| 01/13/2010 | 1794 |
| 01/14/2010 | 1762 |
| Other values (5224) |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 15632150 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 46 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 06/24/2019 |
|---|---|
| 2nd row | 12/22/2019 |
| 3rd row | 01/19/2021 |
| 4th row | 11/25/2020 |
| 5th row | 04/18/2020 |
Common Values
| Value | Count | Frequency (%) |
| 01/22/2019 | 2313 | 0.1% |
| 01/24/2019 | 2130 | 0.1% |
| 01/23/2019 | 1816 | 0.1% |
| 01/13/2010 | 1794 | 0.1% |
| 01/14/2010 | 1762 | 0.1% |
| 01/17/2019 | 1656 | 0.1% |
| 11/28/2018 | 1646 | 0.1% |
| 11/27/2018 | 1453 | 0.1% |
| 01/25/2019 | 1448 | 0.1% |
| 11/29/2018 | 1424 | 0.1% |
| Other values (5219) | 1545773 |
Length
| Value | Count | Frequency (%) |
| 01/22/2019 | 2313 | 0.1% |
| 01/24/2019 | 2130 | 0.1% |
| 01/23/2019 | 1816 | 0.1% |
| 01/13/2010 | 1794 | 0.1% |
| 01/14/2010 | 1762 | 0.1% |
| 01/17/2019 | 1656 | 0.1% |
| 11/28/2018 | 1646 | 0.1% |
| 11/27/2018 | 1453 | 0.1% |
| 01/25/2019 | 1448 | 0.1% |
| 11/29/2018 | 1424 | 0.1% |
| Other values (5219) | 1545773 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 4095304 | |
| / | 3126430 | |
| 2 | 2700418 | |
| 1 | 2466958 | |
| 9 | 566063 | 3.6% |
| 8 | 560925 | 3.6% |
| 7 | 488082 | 3.1% |
| 3 | 450259 | 2.9% |
| 6 | 407050 | 2.6% |
| 5 | 397145 | 2.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 12505720 | |
| Other Punctuation | 3126430 | 20.0% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 4095304 | |
| 2 | 2700418 | |
| 1 | 2466958 | |
| 9 | 566063 | 4.5% |
| 8 | 560925 | 4.5% |
| 7 | 488082 | 3.9% |
| 3 | 450259 | 3.6% |
| 6 | 407050 | 3.3% |
| 5 | 397145 | 3.2% |
| 4 | 373516 | 3.0% |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 3126430 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 15632150 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 4095304 | |
| / | 3126430 | |
| 2 | 2700418 | |
| 1 | 2466958 | |
| 9 | 566063 | 3.6% |
| 8 | 560925 | 3.6% |
| 7 | 488082 | 3.1% |
| 3 | 450259 | 2.9% |
| 6 | 407050 | 2.6% |
| 5 | 397145 | 2.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 15632150 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 4095304 | |
| / | 3126430 | |
| 2 | 2700418 | |
| 1 | 2466958 | |
| 9 | 566063 | 3.6% |
| 8 | 560925 | 3.6% |
| 7 | 488082 | 3.1% |
| 3 | 450259 | 2.9% |
| 6 | 407050 | 2.6% |
| 5 | 397145 | 2.5% |
CREATION TIME
Categorical
| Distinct | 1440 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 11.9 MiB |
| 11:01 AM | 2878 |
|---|---|
| 10:41 AM | 2849 |
| 10:43 AM | 2826 |
| 10:48 AM | 2820 |
| 10:58 AM | 2809 |
| Other values (1435) |
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 8 |
| Min length | 8 |
Characters and Unicode
| Total characters | 12505720 |
|---|---|
| Distinct characters | 15 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 07:40 AM |
|---|---|
| 2nd row | 07:56 PM |
| 3rd row | 02:43 PM |
| 4th row | 09:19 AM |
| 5th row | 05:10 PM |
Common Values
| Value | Count | Frequency (%) |
| 11:01 AM | 2878 | 0.2% |
| 10:41 AM | 2849 | 0.2% |
| 10:43 AM | 2826 | 0.2% |
| 10:48 AM | 2820 | 0.2% |
| 10:58 AM | 2809 | 0.2% |
| 09:48 AM | 2801 | 0.2% |
| 10:55 AM | 2788 | 0.2% |
| 10:54 AM | 2784 | 0.2% |
| 10:50 AM | 2782 | 0.2% |
| 10:32 AM | 2779 | 0.2% |
| Other values (1430) | 1535099 |
Length
| Value | Count | Frequency (%) |
| pm | 879025 | |
| am | 684190 | |
| 11:01 | 2983 | 0.1% |
| 10:41 | 2980 | 0.1% |
| 09:42 | 2940 | 0.1% |
| 09:45 | 2936 | 0.1% |
| 10:43 | 2936 | 0.1% |
| 10:48 | 2930 | 0.1% |
| 09:48 | 2925 | 0.1% |
| 09:41 | 2924 | 0.1% |
| Other values (712) | 1539661 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 1682522 | |
| : | 1563215 | |
| 1563215 | ||
| M | 1563215 | |
| 1 | 1182599 | |
| P | 879025 | |
| 2 | 699543 | |
| A | 684190 | |
| 3 | 562416 | 4.5% |
| 4 | 545820 | 4.4% |
| Other values (5) | 1579960 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 6252860 | |
| Uppercase Letter | 3126430 | |
| Other Punctuation | 1563215 | 12.5% |
| Space Separator | 1563215 | 12.5% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 1682522 | |
| 1 | 1182599 | |
| 2 | 699543 | |
| 3 | 562416 | 9.0% |
| 4 | 545820 | 8.7% |
| 5 | 493755 | 7.9% |
| 9 | 323319 | 5.2% |
| 8 | 304275 | 4.9% |
| 7 | 230814 | 3.7% |
| 6 | 227797 | 3.6% |
Uppercase Letter
| Value | Count | Frequency (%) |
| M | 1563215 | |
| P | 879025 | |
| A | 684190 |
Other Punctuation
| Value | Count | Frequency (%) |
| : | 1563215 |
Space Separator
| Value | Count | Frequency (%) |
| 1563215 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 9379290 | |
| Latin | 3126430 | 25.0% |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 1682522 | |
| : | 1563215 | |
| 1563215 | ||
| 1 | 1182599 | |
| 2 | 699543 | |
| 3 | 562416 | 6.0% |
| 4 | 545820 | 5.8% |
| 5 | 493755 | 5.3% |
| 9 | 323319 | 3.4% |
| 8 | 304275 | 3.2% |
| Other values (2) | 458611 | 4.9% |
Latin
| Value | Count | Frequency (%) |
| M | 1563215 | |
| P | 879025 | |
| A | 684190 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 12505720 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 1682522 | |
| : | 1563215 | |
| 1563215 | ||
| M | 1563215 | |
| 1 | 1182599 | |
| P | 879025 | |
| 2 | 699543 | |
| A | 684190 | |
| 3 | 562416 | 4.5% |
| 4 | 545820 | 4.4% |
| Other values (5) | 1579960 |
CREATION MONTH
Real number (ℝ)
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.2869618 |
| Minimum | 1 |
|---|---|
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 11.9 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 6 |
| Q3 | 9 |
| 95-th percentile | 12 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 3.3485904 |
|---|---|
| Coefficient of variation (CV) | 0.53262458 |
| Kurtosis | -1.1016162 |
| Mean | 6.2869618 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 0.063491463 |
| Sum | 9827873 |
| Variance | 11.213058 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 5 | 152005 | |
| 6 | 150000 | |
| 1 | 143890 | |
| 8 | 141492 | |
| 7 | 140286 | |
| 4 | 131977 | |
| 3 | 126558 | |
| 9 | 125359 | |
| 2 | 121288 | |
| 10 | 116238 | |
| Other values (2) | 214122 |
| Value | Count | Frequency (%) |
| 1 | 143890 | |
| 2 | 121288 | |
| 3 | 126558 | |
| 4 | 131977 | |
| 5 | 152005 | |
| 6 | 150000 | |
| 7 | 140286 | |
| 8 | 141492 | |
| 9 | 125359 | |
| 10 | 116238 |
| Value | Count | Frequency (%) |
| 12 | 113909 | |
| 11 | 100213 | |
| 10 | 116238 | |
| 9 | 125359 | |
| 8 | 141492 | |
| 7 | 140286 | |
| 6 | 150000 | |
| 5 | 152005 | |
| 4 | 131977 | |
| 3 | 126558 |
CREATION YEAR
Real number (ℝ)
| Distinct | 16 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2013.9035 |
| Minimum | 2006 |
|---|---|
| Maximum | 2021 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 11.9 MiB |
Quantile statistics
| Minimum | 2006 |
|---|---|
| 5-th percentile | 2007 |
| Q1 | 2010 |
| median | 2014 |
| Q3 | 2018 |
| 95-th percentile | 2020 |
| Maximum | 2021 |
| Range | 15 |
| Interquartile range (IQR) | 8 |
Descriptive statistics
| Standard deviation | 4.2488245 |
|---|---|
| Coefficient of variation (CV) | 0.0021097458 |
| Kurtosis | -1.3473795 |
| Mean | 2013.9035 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | -0.074539278 |
| Sum | 3.1481642 × 109 |
| Variance | 18.05251 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2019 | 166021 | |
| 2008 | 137894 | 8.8% |
| 2020 | 125906 | 8.1% |
| 2018 | 124280 | 8.0% |
| 2009 | 119269 | 7.6% |
| 2010 | 110276 | 7.1% |
| 2017 | 109811 | 7.0% |
| 2016 | 103955 | 6.7% |
| 2015 | 96941 | 6.2% |
| 2011 | 96113 | 6.1% |
| Other values (6) | 372749 |
| Value | Count | Frequency (%) |
| 2006 | 1 | < 0.1% |
| 2007 | 83075 | |
| 2008 | 137894 | |
| 2009 | 119269 | |
| 2010 | 110276 | |
| 2011 | 96113 | |
| 2012 | 90199 | |
| 2013 | 90462 | |
| 2014 | 89329 | |
| 2015 | 96941 |
| Value | Count | Frequency (%) |
| 2021 | 19683 | 1.3% |
| 2020 | 125906 | |
| 2019 | 166021 | |
| 2018 | 124280 | |
| 2017 | 109811 | |
| 2016 | 103955 | |
| 2015 | 96941 | |
| 2014 | 89329 | |
| 2013 | 90462 | |
| 2012 | 90199 |
STATUS
Categorical
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 11.9 MiB |
| RESOL | |
|---|---|
| CANC | 13818 |
| OPEN | 12657 |
| DUP | 1301 |
| ASSIG | 45 |
Length
| Max length | 5 |
|---|---|
| Median length | 5 |
| Mean length | 4.981396 |
| Min length | 3 |
Characters and Unicode
| Total characters | 7786993 |
|---|---|
| Distinct characters | 14 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | RESOL |
|---|---|
| 2nd row | RESOL |
| 3rd row | RESOL |
| 4th row | RESOL |
| 5th row | RESOL |
Common Values
| Value | Count | Frequency (%) |
| RESOL | 1535389 | |
| CANC | 13818 | 0.9% |
| OPEN | 12657 | 0.8% |
| DUP | 1301 | 0.1% |
| ASSIG | 45 | < 0.1% |
| FAIL | 5 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| resol | 1535389 | |
| canc | 13818 | 0.9% |
| open | 12657 | 0.8% |
| dup | 1301 | 0.1% |
| assig | 45 | < 0.1% |
| fail | 5 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 1548046 | |
| O | 1548046 | |
| S | 1535479 | |
| L | 1535394 | |
| R | 1535389 | |
| C | 27636 | 0.4% |
| N | 26475 | 0.3% |
| P | 13958 | 0.2% |
| A | 13868 | 0.2% |
| D | 1301 | < 0.1% |
| Other values (4) | 1401 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 7786993 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 1548046 | |
| O | 1548046 | |
| S | 1535479 | |
| L | 1535394 | |
| R | 1535389 | |
| C | 27636 | 0.4% |
| N | 26475 | 0.3% |
| P | 13958 | 0.2% |
| A | 13868 | 0.2% |
| D | 1301 | < 0.1% |
| Other values (4) | 1401 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 7786993 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| E | 1548046 | |
| O | 1548046 | |
| S | 1535479 | |
| L | 1535394 | |
| R | 1535389 | |
| C | 27636 | 0.4% |
| N | 26475 | 0.3% |
| P | 13958 | 0.2% |
| A | 13868 | 0.2% |
| D | 1301 | < 0.1% |
| Other values (4) | 1401 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 7786993 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| E | 1548046 | |
| O | 1548046 | |
| S | 1535479 | |
| L | 1535394 | |
| R | 1535389 | |
| C | 27636 | 0.4% |
| N | 26475 | 0.3% |
| P | 13958 | 0.2% |
| A | 13868 | 0.2% |
| D | 1301 | < 0.1% |
| Other values (4) | 1401 | < 0.1% |
EXCEEDED EST TIMEFRAME
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 23 |
| Missing (%) | < 0.1% |
| Memory size | 3.0 MiB |
| False | |
|---|---|
| True | |
| (Missing) | 23 |
| Value | Count | Frequency (%) |
| False | 1079493 | |
| True | 483699 | |
| (Missing) | 23 | < 0.1% |
CLOSED DATE
Categorical
| Distinct | 4995 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 12702 |
| Missing (%) | 0.8% |
| Memory size | 11.9 MiB |
| 09/30/2019 | 13841 |
|---|---|
| 05/05/2014 | 4595 |
| 03/25/2019 | 3471 |
| 02/23/2010 | 3313 |
| 12/03/2018 | 3281 |
| Other values (4990) |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 15505130 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 169 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 11/19/2021 |
|---|---|
| 2nd row | 06/26/2020 |
| 3rd row | 11/15/2021 |
| 4th row | 04/26/2021 |
| 5th row | 04/30/2020 |
Common Values
| Value | Count | Frequency (%) |
| 09/30/2019 | 13841 | 0.9% |
| 05/05/2014 | 4595 | 0.3% |
| 03/25/2019 | 3471 | 0.2% |
| 02/23/2010 | 3313 | 0.2% |
| 12/03/2018 | 3281 | 0.2% |
| 04/05/2019 | 2863 | 0.2% |
| 07/29/2009 | 2764 | 0.2% |
| 02/14/2019 | 1988 | 0.1% |
| 02/13/2019 | 1838 | 0.1% |
| 02/21/2019 | 1794 | 0.1% |
| Other values (4985) | 1510765 | |
| (Missing) | 12702 | 0.8% |
Length
| Value | Count | Frequency (%) |
| 09/30/2019 | 13841 | 0.9% |
| 05/05/2014 | 4595 | 0.3% |
| 03/25/2019 | 3471 | 0.2% |
| 02/23/2010 | 3313 | 0.2% |
| 12/03/2018 | 3281 | 0.2% |
| 04/05/2019 | 2863 | 0.2% |
| 07/29/2009 | 2764 | 0.2% |
| 02/14/2019 | 1988 | 0.1% |
| 02/13/2019 | 1838 | 0.1% |
| 02/21/2019 | 1794 | 0.1% |
| Other values (4985) | 1510765 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 4033809 | |
| / | 3101026 | |
| 2 | 2686065 | |
| 1 | 2487899 | |
| 9 | 588607 | 3.8% |
| 8 | 528897 | 3.4% |
| 7 | 474108 | 3.1% |
| 3 | 467330 | 3.0% |
| 6 | 397554 | 2.6% |
| 5 | 379896 | 2.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 12404104 | |
| Other Punctuation | 3101026 | 20.0% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 4033809 | |
| 2 | 2686065 | |
| 1 | 2487899 | |
| 9 | 588607 | 4.7% |
| 8 | 528897 | 4.3% |
| 7 | 474108 | 3.8% |
| 3 | 467330 | 3.8% |
| 6 | 397554 | 3.2% |
| 5 | 379896 | 3.1% |
| 4 | 359939 | 2.9% |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 3101026 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 15505130 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 4033809 | |
| / | 3101026 | |
| 2 | 2686065 | |
| 1 | 2487899 | |
| 9 | 588607 | 3.8% |
| 8 | 528897 | 3.4% |
| 7 | 474108 | 3.1% |
| 3 | 467330 | 3.0% |
| 6 | 397554 | 2.6% |
| 5 | 379896 | 2.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 15505130 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 4033809 | |
| / | 3101026 | |
| 2 | 2686065 | |
| 1 | 2487899 | |
| 9 | 588607 | 3.8% |
| 8 | 528897 | 3.4% |
| 7 | 474108 | 3.1% |
| 3 | 467330 | 3.0% |
| 6 | 397554 | 2.6% |
| 5 | 379896 | 2.5% |
CLOSED MONTH
Real number (ℝ)
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 26515 |
| Missing (%) | 1.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.4092647 |
| Minimum | 1 |
|---|---|
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 11.9 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 6 |
| Q3 | 9 |
| 95-th percentile | 12 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 3.3998366 |
|---|---|
| Coefficient of variation (CV) | 0.53045659 |
| Kurtosis | -1.1648866 |
| Mean | 6.4092647 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 0.025655982 |
| Sum | 9849117 |
| Variance | 11.558889 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 6 | 139557 | |
| 7 | 139100 | |
| 5 | 133823 | |
| 8 | 133050 | |
| 3 | 132449 | |
| 1 | 129537 | |
| 2 | 128834 | |
| 10 | 127722 | |
| 9 | 124401 | |
| 12 | 122014 | |
| Other values (2) | 226213 |
| Value | Count | Frequency (%) |
| 1 | 129537 | |
| 2 | 128834 | |
| 3 | 132449 | |
| 4 | 118476 | |
| 5 | 133823 | |
| 6 | 139557 | |
| 7 | 139100 | |
| 8 | 133050 | |
| 9 | 124401 | |
| 10 | 127722 |
| Value | Count | Frequency (%) |
| 12 | 122014 | |
| 11 | 107737 | |
| 10 | 127722 | |
| 9 | 124401 | |
| 8 | 133050 | |
| 7 | 139100 | |
| 6 | 139557 | |
| 5 | 133823 | |
| 4 | 118476 | |
| 3 | 132449 |
CLOSED YEAR
Real number (ℝ)
| Distinct | 16 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 26515 |
| Missing (%) | 1.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2014.0239 |
| Minimum | 2007 |
|---|---|
| Maximum | 2022 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 11.9 MiB |
Quantile statistics
| Minimum | 2007 |
|---|---|
| 5-th percentile | 2008 |
| Q1 | 2010 |
| median | 2014 |
| Q3 | 2018 |
| 95-th percentile | 2020 |
| Maximum | 2022 |
| Range | 15 |
| Interquartile range (IQR) | 8 |
Descriptive statistics
| Standard deviation | 4.2253652 |
|---|---|
| Coefficient of variation (CV) | 0.0020979717 |
| Kurtosis | -1.3244347 |
| Mean | 2014.0239 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | -0.098468027 |
| Sum | 3.0949505 × 109 |
| Variance | 17.853711 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2019 | 165353 | |
| 2018 | 123273 | 7.9% |
| 2008 | 123016 | 7.9% |
| 2020 | 122641 | 7.8% |
| 2009 | 119223 | 7.6% |
| 2017 | 111686 | 7.1% |
| 2016 | 104931 | 6.7% |
| 2011 | 101907 | 6.5% |
| 2010 | 101188 | 6.5% |
| 2015 | 92506 | 5.9% |
| Other values (6) | 370976 |
| Value | Count | Frequency (%) |
| 2007 | 75817 | |
| 2008 | 123016 | |
| 2009 | 119223 | |
| 2010 | 101188 | |
| 2011 | 101907 | |
| 2012 | 88661 | |
| 2013 | 88566 | |
| 2014 | 91518 | |
| 2015 | 92506 | |
| 2016 | 104931 |
| Value | Count | Frequency (%) |
| 2022 | 9 | < 0.1% |
| 2021 | 26405 | 1.7% |
| 2020 | 122641 | |
| 2019 | 165353 | |
| 2018 | 123273 | |
| 2017 | 111686 | |
| 2016 | 104931 | |
| 2015 | 92506 | |
| 2014 | 91518 | |
| 2013 | 88566 |
DAYS TO CLOSE
Real number (ℝ)
MISSING  ZEROS 
| Distinct | 2748 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 26515 |
| Missing (%) | 1.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 51.533404 |
| Minimum | -21 |
|---|---|
| Maximum | 4525 |
| Zeros | 150614 |
| Zeros (%) | 9.6% |
| Negative | 29 |
| Negative (%) | < 0.1% |
| Memory size | 11.9 MiB |
Quantile statistics
| Minimum | -21 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 4 |
| Q3 | 23 |
| 95-th percentile | 261 |
| Maximum | 4525 |
| Range | 4546 |
| Interquartile range (IQR) | 22 |
Descriptive statistics
| Standard deviation | 169.57318 |
|---|---|
| Coefficient of variation (CV) | 3.2905488 |
| Kurtosis | 77.017163 |
| Mean | 51.533404 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 7.3881016 |
| Sum | 79191382 |
| Variance | 28755.063 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 322471 | |
| 0 | 150614 | 9.6% |
| 2 | 120416 | 7.7% |
| 3 | 103139 | 6.6% |
| 4 | 77824 | 5.0% |
| 5 | 57503 | 3.7% |
| 6 | 49736 | 3.2% |
| 7 | 44990 | 2.9% |
| 8 | 31128 | 2.0% |
| 9 | 20513 | 1.3% |
| Other values (2738) | 558366 | |
| (Missing) | 26515 | 1.7% |
| Value | Count | Frequency (%) |
| -21 | 17 | < 0.1% |
| -20 | 2 | < 0.1% |
| -19 | 8 | < 0.1% |
| -18 | 1 | < 0.1% |
| -1 | 1 | < 0.1% |
| 0 | 150614 | |
| 1 | 322471 | |
| 2 | 120416 | 7.7% |
| 3 | 103139 | 6.6% |
| 4 | 77824 | 5.0% |
| Value | Count | Frequency (%) |
| 4525 | 1 | |
| 4471 | 1 | |
| 4396 | 1 | |
| 4188 | 1 | |
| 4183 | 1 | |
| 4175 | 1 | |
| 4160 | 1 | |
| 4157 | 1 | |
| 4135 | 1 | |
| 4132 | 1 |
STREET ADDRESS
Categorical
| Distinct | 277728 |
|---|---|
| Distinct (%) | 17.8% |
| Missing | 24 |
| Missing (%) | < 0.1% |
| Memory size | 11.9 MiB |
| 414 E 12TH ST | 3351 |
|---|---|
| 414 E 12th St | 2421 |
| 4800 E 63rd St | 2330 |
| 415 E 12th St | 1246 |
| 415 E 12th st | 570 |
| Other values (277723) |
Length
| Max length | 39 |
|---|---|
| Median length | 37 |
| Mean length | 15.80865 |
| Min length | 4 |
Characters and Unicode
| Total characters | 24711939 |
|---|---|
| Distinct characters | 75 |
| Distinct categories | 8 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 67349 ? |
|---|---|
| Unique (%) | 4.3% |
Sample
| 1st row | 2317 E 50th St |
|---|---|
| 2nd row | 10329 N Forest Ave |
| 3rd row | 2623 E 10th St |
| 4th row | 2474 Chelsea Ave |
| 5th row | 400 W 31st St |
Common Values
| Value | Count | Frequency (%) |
| 414 E 12TH ST | 3351 | 0.2% |
| 414 E 12th St | 2421 | 0.2% |
| 4800 E 63rd St | 2330 | 0.1% |
| 415 E 12th St | 1246 | 0.1% |
| 415 E 12th st | 570 | < 0.1% |
| 400 W 31st St | 430 | < 0.1% |
| 5100 Wornall Rd | 323 | < 0.1% |
| 2400 Troost Ave | 290 | < 0.1% |
| 4900 Raytown Rd | 282 | < 0.1% |
| 7750 E Front St | 269 | < 0.1% |
| Other values (277718) | 1551679 |
Length
| Value | Count | Frequency (%) |
| ave | 602207 | 10.9% |
| st | 476456 | 8.6% |
| e | 327586 | 5.9% |
| n | 180177 | 3.3% |
| ter | 156915 | 2.8% |
| rd | 131274 | 2.4% |
| ne | 112479 | 2.0% |
| w | 70394 | 1.3% |
| blvd | 64833 | 1.2% |
| nw | 64756 | 1.2% |
| Other values (12145) | 3334294 |
Most occurring characters
| Value | Count | Frequency (%) |
| 3958210 | 16.0% | |
| 1 | 1284556 | 5.2% |
| 0 | 1173280 | 4.7% |
| E | 1116467 | 4.5% |
| e | 909295 | 3.7% |
| A | 892797 | 3.6% |
| 2 | 785798 | 3.2% |
| t | 762941 | 3.1% |
| T | 726450 | 2.9% |
| 3 | 717530 | 2.9% |
| Other values (65) | 12384615 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 7637289 | |
| Decimal Number | 7183875 | |
| Lowercase Letter | 5925190 | |
| Space Separator | 3958210 | |
| Dash Punctuation | 5688 | < 0.1% |
| Other Punctuation | 1677 | < 0.1% |
| Open Punctuation | 5 | < 0.1% |
| Close Punctuation | 5 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 1116467 | |
| A | 892797 | |
| T | 726450 | 9.5% |
| S | 694753 | 9.1% |
| N | 661679 | 8.7% |
| R | 501664 | 6.6% |
| V | 331386 | 4.3% |
| W | 291712 | 3.8% |
| L | 290404 | 3.8% |
| O | 286483 | 3.8% |
| Other values (16) | 1843494 |
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 909295 | |
| t | 762941 | |
| r | 482556 | |
| v | 427188 | 7.2% |
| n | 420855 | 7.1% |
| a | 372413 | 6.3% |
| o | 364188 | 6.1% |
| l | 354868 | 6.0% |
| d | 338821 | 5.7% |
| h | 306003 | 5.2% |
| Other values (16) | 1186062 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 1284556 | |
| 0 | 1173280 | |
| 2 | 785798 | |
| 3 | 717530 | |
| 4 | 714711 | |
| 5 | 619841 | |
| 6 | 496732 | 6.9% |
| 7 | 496633 | 6.9% |
| 8 | 477639 | 6.6% |
| 9 | 417155 | 5.8% |
Other Punctuation
| Value | Count | Frequency (%) |
| ' | 1342 | |
| , | 100 | 6.0% |
| . | 70 | 4.2% |
| / | 70 | 4.2% |
| # | 68 | 4.1% |
| & | 13 | 0.8% |
| " | 10 | 0.6% |
| : | 3 | 0.2% |
| % | 1 | 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 3958210 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 5688 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 5 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 5 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 13562479 | |
| Common | 11149460 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| E | 1116467 | 8.2% |
| e | 909295 | 6.7% |
| A | 892797 | 6.6% |
| t | 762941 | 5.6% |
| T | 726450 | 5.4% |
| S | 694753 | 5.1% |
| N | 661679 | 4.9% |
| R | 501664 | 3.7% |
| r | 482556 | 3.6% |
| v | 427188 | 3.1% |
| Other values (42) | 6386689 |
Common
| Value | Count | Frequency (%) |
| 3958210 | ||
| 1 | 1284556 | 11.5% |
| 0 | 1173280 | 10.5% |
| 2 | 785798 | 7.0% |
| 3 | 717530 | 6.4% |
| 4 | 714711 | 6.4% |
| 5 | 619841 | 5.6% |
| 6 | 496732 | 4.5% |
| 7 | 496633 | 4.5% |
| 8 | 477639 | 4.3% |
| Other values (13) | 424530 | 3.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 24711939 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 3958210 | 16.0% | |
| 1 | 1284556 | 5.2% |
| 0 | 1173280 | 4.7% |
| E | 1116467 | 4.5% |
| e | 909295 | 3.7% |
| A | 892797 | 3.6% |
| 2 | 785798 | 3.2% |
| t | 762941 | 3.1% |
| T | 726450 | 2.9% |
| 3 | 717530 | 2.9% |
| Other values (65) | 12384615 |
ADDRESS WITH GEOCODE
Categorical
| Distinct | 307249 |
|---|---|
| Distinct (%) | 19.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 11.9 MiB |
| 414 E 12th St64106 (39.100387, -94.577919) | 2422 |
|---|---|
| 414 E 12TH ST64106 (39.100387, -94.577919) | 2414 |
| 4800 E 63rd St64130 (39.014493, -94.529933) | 2330 |
| 415 E 12th St64106 (39.099123, -94.577983) | 1246 |
| 414 E 12TH ST64106 (35.797519, -103.890579) | 963 |
| Other values (307244) |
Length
| Max length | 69 |
|---|---|
| Median length | 66 |
| Mean length | 44.602594 |
| Min length | 19 |
Characters and Unicode
| Total characters | 69723444 |
|---|---|
| Distinct characters | 73 |
| Distinct categories | 9 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 84541 ? |
|---|---|
| Unique (%) | 5.4% |
Sample
| 1st row | 2317 E 50th St64130 (39.035489, -94.557309) |
|---|---|
| 2nd row | 10329 N Forest Ave64155 (39.28196, -94.564453) |
| 3rd row | 2623 E 10th St64127 (39.101272, -94.549951) |
| 4th row | 2474 Chelsea Ave64127 (39.079895, -94.526959) |
| 5th row | 400 W 31st St64108 (39.074934, -94.591904) |
Common Values
| Value | Count | Frequency (%) |
| 414 E 12th St64106 (39.100387, -94.577919) | 2422 | 0.2% |
| 414 E 12TH ST64106 (39.100387, -94.577919) | 2414 | 0.2% |
| 4800 E 63rd St64130 (39.014493, -94.529933) | 2330 | 0.1% |
| 415 E 12th St64106 (39.099123, -94.577983) | 1246 | 0.1% |
| 414 E 12TH ST64106 (35.797519, -103.890579) | 963 | 0.1% |
| 415 E 12th st64106 (35.797519, -103.890579) | 570 | < 0.1% |
| 400 W 31st St64108 (39.074934, -94.591904) | 430 | < 0.1% |
| 5100 Wornall Rd64112 (39.031378, -94.59448) | 323 | < 0.1% |
| 7750 E Front St64120 (39.136326, -94.490605) | 260 | < 0.1% |
| 2400 Troost Ave64108 (39.083166, -94.572049) | 259 | < 0.1% |
| Other values (307239) | 1551998 |
Length
| Value | Count | Frequency (%) |
| e | 327581 | 3.8% |
| n | 180180 | 2.1% |
| ne | 112478 | 1.3% |
| ave64130 | 85500 | 1.0% |
| w | 70398 | 0.8% |
| nw | 64756 | 0.7% |
| ave64127 | 60184 | 0.7% |
| ave64128 | 46863 | 0.5% |
| 103.890579 | 40610 | 0.5% |
| 35.797519 | 40597 | 0.5% |
| Other values (296654) | 7617276 |
Most occurring characters
| Value | Count | Frequency (%) |
| 4 | 5770240 | 8.3% |
| 5514815 | 7.9% | |
| 9 | 5341801 | 7.7% |
| 1 | 5255076 | 7.5% |
| 3 | 4454744 | 6.4% |
| 6 | 3830032 | 5.5% |
| 5 | 3688003 | 5.3% |
| 0 | 3456592 | 5.0% |
| . | 3126428 | 4.5% |
| 2 | 2886725 | 4.1% |
| Other values (63) | 26398988 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 39699460 | |
| Uppercase Letter | 7629706 | 10.9% |
| Lowercase Letter | 5925053 | 8.5% |
| Space Separator | 5514815 | 7.9% |
| Other Punctuation | 4691127 | 6.7% |
| Dash Punctuation | 1568457 | 2.2% |
| Control | 1568393 | 2.2% |
| Open Punctuation | 1563219 | 2.2% |
| Close Punctuation | 1563214 | 2.2% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 1115885 | |
| A | 892378 | |
| T | 725629 | 9.5% |
| S | 694142 | 9.1% |
| N | 661564 | 8.7% |
| R | 501575 | 6.6% |
| V | 331377 | 4.3% |
| W | 291634 | 3.8% |
| L | 289072 | 3.8% |
| O | 286424 | 3.8% |
| Other values (16) | 1840026 |
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 909283 | |
| t | 762909 | |
| r | 482551 | |
| v | 427187 | 7.2% |
| n | 420848 | 7.1% |
| a | 372405 | 6.3% |
| o | 364182 | 6.1% |
| l | 354864 | 6.0% |
| d | 338815 | 5.7% |
| h | 305998 | 5.2% |
| Other values (16) | 1186011 |
Decimal Number
| Value | Count | Frequency (%) |
| 4 | 5770240 | |
| 9 | 5341801 | |
| 1 | 5255076 | |
| 3 | 4454744 | |
| 6 | 3830032 | |
| 5 | 3688003 | |
| 0 | 3456592 | |
| 2 | 2886725 | |
| 8 | 2653764 | |
| 7 | 2362483 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 3126428 | |
| , | 1563343 | |
| ' | 1342 | < 0.1% |
| & | 11 | < 0.1% |
| # | 2 | < 0.1% |
| % | 1 | < 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 5514815 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 1568457 |
Control
| Value | Count | Frequency (%) |
| 1568393 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 1563219 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 1563214 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 56168685 | |
| Latin | 13554759 | 19.4% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| E | 1115885 | 8.2% |
| e | 909283 | 6.7% |
| A | 892378 | 6.6% |
| t | 762909 | 5.6% |
| T | 725629 | 5.4% |
| S | 694142 | 5.1% |
| N | 661564 | 4.9% |
| R | 501575 | 3.7% |
| r | 482551 | 3.6% |
| v | 427187 | 3.2% |
| Other values (42) | 6381656 |
Common
| Value | Count | Frequency (%) |
| 4 | 5770240 | |
| 5514815 | ||
| 9 | 5341801 | |
| 1 | 5255076 | |
| 3 | 4454744 | 7.9% |
| 6 | 3830032 | 6.8% |
| 5 | 3688003 | 6.6% |
| 0 | 3456592 | 6.2% |
| . | 3126428 | 5.6% |
| 2 | 2886725 | 5.1% |
| Other values (11) | 12844229 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 69723444 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 4 | 5770240 | 8.3% |
| 5514815 | 7.9% | |
| 9 | 5341801 | 7.7% |
| 1 | 5255076 | 7.5% |
| 3 | 4454744 | 6.4% |
| 6 | 3830032 | 5.5% |
| 5 | 3688003 | 5.3% |
| 0 | 3456592 | 5.0% |
| . | 3126428 | 4.5% |
| 2 | 2886725 | 4.1% |
| Other values (63) | 26398988 |
ZIP CODE
Real number (ℝ)
| Distinct | 65 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 826 |
| Missing (%) | 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 64126.843 |
| Minimum | 4114 |
|---|---|
| Maximum | 66203 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 11.9 MiB |
Quantile statistics
| Minimum | 4114 |
|---|---|
| 5-th percentile | 64109 |
| Q1 | 64116 |
| median | 64128 |
| Q3 | 64133 |
| 95-th percentile | 64155 |
| Maximum | 66203 |
| Range | 62089 |
| Interquartile range (IQR) | 17 |
Descriptive statistics
| Standard deviation | 68.122948 |
|---|---|
| Coefficient of variation (CV) | 0.0010623156 |
| Kurtosis | 721225.59 |
| Mean | 64126.843 |
| Median Absolute Deviation (MAD) | 9 |
| Skewness | -832.06849 |
| Sum | 1.0019107 × 1011 |
| Variance | 4640.7361 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 64130 | 133154 | 8.5% |
| 64127 | 90867 | 5.8% |
| 64114 | 83166 | 5.3% |
| 64134 | 77097 | 4.9% |
| 64131 | 76437 | 4.9% |
| 64132 | 76361 | 4.9% |
| 64128 | 73073 | 4.7% |
| 64110 | 64771 | 4.1% |
| 64119 | 57224 | 3.7% |
| 64111 | 50195 | 3.2% |
| Other values (55) | 780044 |
| Value | Count | Frequency (%) |
| 4114 | 1 | < 0.1% |
| 6152 | 1 | < 0.1% |
| 63130 | 1 | < 0.1% |
| 64012 | 39 | < 0.1% |
| 64028 | 22 | < 0.1% |
| 64030 | 27 | < 0.1% |
| 64052 | 47 | < 0.1% |
| 64053 | 115 | |
| 64055 | 28 | < 0.1% |
| 64068 | 280 |
| Value | Count | Frequency (%) |
| 66203 | 1 | < 0.1% |
| 64444 | 15 | < 0.1% |
| 64167 | 194 | < 0.1% |
| 64166 | 460 | < 0.1% |
| 64165 | 486 | < 0.1% |
| 64164 | 522 | < 0.1% |
| 64163 | 1160 | 0.1% |
| 64161 | 1936 | 0.1% |
| 64160 | 89 | < 0.1% |
| 64158 | 6892 |
NEIGHBORHOOD
Categorical
HIGH CARDINALITY  MISSING 
| Distinct | 250 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 46106 |
| Missing (%) | 2.9% |
| Memory size | 11.9 MiB |
| Shoal Creek | 55839 |
|---|---|
| Blue Hills | 31462 |
| East Community Team South | 21706 |
| Scarritt Point | 21295 |
| South Indian Mound | 20710 |
| Other values (245) |
Length
| Max length | 42 |
|---|---|
| Median length | 29 |
| Mean length | 14.972397 |
| Min length | 2 |
Characters and Unicode
| Total characters | 22714758 |
|---|---|
| Distinct characters | 60 |
| Distinct categories | 6 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Blue Hills |
|---|---|
| 2nd row | New Mark |
| 3rd row | Independence Plaza |
| 4th row | East Community Team South |
| 5th row | Westside South |
Common Values
| Value | Count | Frequency (%) |
| Shoal Creek | 55839 | 3.6% |
| Blue Hills | 31462 | 2.0% |
| East Community Team South | 21706 | 1.4% |
| Scarritt Point | 21295 | 1.4% |
| South Indian Mound | 20710 | 1.3% |
| Lykins | 20441 | 1.3% |
| Tower Homes | 20031 | 1.3% |
| CBD Downtown | 18486 | 1.2% |
| North Indian Mound | 17872 | 1.1% |
| Swope Parkway-Elmwood | 17792 | 1.1% |
| Other values (240) | 1271475 | |
| (Missing) | 46106 | 2.9% |
Length
| Value | Count | Frequency (%) |
| park | 147748 | 4.3% |
| hills | 128098 | 3.7% |
| east | 108867 | 3.2% |
| creek | 104581 | 3.0% |
| blue | 98087 | 2.8% |
| south | 98018 | 2.8% |
| north | 94066 | 2.7% |
| and | 77209 | 2.2% |
| shoal | 59166 | 1.7% |
| oak | 59067 | 1.7% |
| Other values (269) | 2476354 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 2024521 | 8.9% |
| 1934152 | 8.5% | |
| a | 1649498 | 7.3% |
| o | 1561057 | 6.9% |
| r | 1370100 | 6.0% |
| t | 1291903 | 5.7% |
| l | 1174709 | 5.2% |
| n | 1168235 | 5.1% |
| s | 1134269 | 5.0% |
| i | 1065864 | 4.7% |
| Other values (50) | 8340450 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 17008571 | |
| Uppercase Letter | 3515573 | 15.5% |
| Space Separator | 1934152 | 8.5% |
| Decimal Number | 140924 | 0.6% |
| Dash Punctuation | 82454 | 0.4% |
| Other Punctuation | 33084 | 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 2024521 | |
| a | 1649498 | |
| o | 1561057 | |
| r | 1370100 | 8.1% |
| t | 1291903 | 7.6% |
| l | 1174709 | 6.9% |
| n | 1168235 | 6.9% |
| s | 1134269 | 6.7% |
| i | 1065864 | 6.3% |
| h | 746484 | 4.4% |
| Other values (15) | 3821931 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 367459 | 10.5% |
| C | 360417 | 10.3% |
| H | 349438 | 9.9% |
| P | 322701 | 9.2% |
| W | 224225 | 6.4% |
| M | 205260 | 5.8% |
| E | 203178 | 5.8% |
| B | 195938 | 5.6% |
| N | 186385 | 5.3% |
| R | 155777 | 4.4% |
| Other values (13) | 944795 |
Decimal Number
| Value | Count | Frequency (%) |
| 6 | 37402 | |
| 9 | 25165 | |
| 4 | 25165 | |
| 3 | 25165 | |
| 2 | 13161 | 9.3% |
| 7 | 10056 | 7.1% |
| 1 | 2405 | 1.7% |
| 8 | 2405 | 1.7% |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 19923 | |
| & | 13161 |
Space Separator
| Value | Count | Frequency (%) |
| 1934152 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 82454 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 20524144 | |
| Common | 2190614 | 9.6% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 2024521 | 9.9% |
| a | 1649498 | 8.0% |
| o | 1561057 | 7.6% |
| r | 1370100 | 6.7% |
| t | 1291903 | 6.3% |
| l | 1174709 | 5.7% |
| n | 1168235 | 5.7% |
| s | 1134269 | 5.5% |
| i | 1065864 | 5.2% |
| h | 746484 | 3.6% |
| Other values (38) | 7337504 |
Common
| Value | Count | Frequency (%) |
| 1934152 | ||
| - | 82454 | 3.8% |
| 6 | 37402 | 1.7% |
| 9 | 25165 | 1.1% |
| 4 | 25165 | 1.1% |
| 3 | 25165 | 1.1% |
| / | 19923 | 0.9% |
| 2 | 13161 | 0.6% |
| & | 13161 | 0.6% |
| 7 | 10056 | 0.5% |
| Other values (2) | 4810 | 0.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 22714758 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 2024521 | 8.9% |
| 1934152 | 8.5% | |
| a | 1649498 | 7.3% |
| o | 1561057 | 6.9% |
| r | 1370100 | 6.0% |
| t | 1291903 | 5.7% |
| l | 1174709 | 5.2% |
| n | 1168235 | 5.1% |
| s | 1134269 | 5.0% |
| i | 1065864 | 4.7% |
| Other values (50) | 8340450 |
COUNTY
Categorical
IMBALANCE  MISSING 
| Distinct | 13 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 66959 |
| Missing (%) | 4.3% |
| Memory size | 11.9 MiB |
| Jackson | |
|---|---|
| Clay | |
| Platte | 80799 |
| CLAY | 573 |
| Cass | 228 |
| Other values (8) | 292 |
Length
| Max length | 13 |
|---|---|
| Median length | 7 |
| Mean length | 6.4463307 |
| Min length | 4 |
Characters and Unicode
| Total characters | 9645361 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 3 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Jackson |
|---|---|
| 2nd row | Clay |
| 3rd row | Jackson |
| 4th row | Jackson |
| 5th row | Jackson |
Common Values
| Value | Count | Frequency (%) |
| Jackson | 1165976 | |
| Clay | 248388 | 15.9% |
| Platte | 80799 | 5.2% |
| CLAY | 573 | < 0.1% |
| Cass | 228 | < 0.1% |
| JACKSON | 219 | < 0.1% |
| jackson | 41 | < 0.1% |
| clay | 23 | < 0.1% |
| platte | 4 | < 0.1% |
| Platte County | 2 | < 0.1% |
| Other values (3) | 3 | < 0.1% |
| (Missing) | 66959 | 4.3% |
Length
| Value | Count | Frequency (%) |
| jackson | 1166236 | |
| clay | 248984 | 16.6% |
| platte | 80806 | 5.4% |
| cass | 228 | < 0.1% |
| county | 2 | < 0.1% |
| clayl | 1 | < 0.1% |
| ackson | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 1495463 | |
| s | 1166474 | |
| J | 1166195 | |
| c | 1166041 | |
| o | 1166020 | |
| n | 1166020 | |
| k | 1166018 | |
| l | 329218 | 3.4% |
| C | 249411 | 2.6% |
| y | 248414 | 2.6% |
| Other values (16) | 326087 | 3.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 8146132 | |
| Uppercase Letter | 1499227 | 15.5% |
| Space Separator | 2 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 1495463 | |
| s | 1166474 | |
| c | 1166041 | |
| o | 1166020 | |
| n | 1166020 | |
| k | 1166018 | |
| l | 329218 | 4.0% |
| y | 248414 | 3.0% |
| t | 161612 | 2.0% |
| e | 80805 | 1.0% |
| Other values (3) | 47 | < 0.1% |
Uppercase Letter
| Value | Count | Frequency (%) |
| J | 1166195 | |
| C | 249411 | 16.6% |
| P | 80802 | 5.4% |
| A | 793 | 0.1% |
| L | 574 | < 0.1% |
| Y | 573 | < 0.1% |
| K | 219 | < 0.1% |
| S | 219 | < 0.1% |
| O | 219 | < 0.1% |
| N | 219 | < 0.1% |
| Other values (2) | 3 | < 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 2 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 9645359 | |
| Common | 2 | < 0.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 1495463 | |
| s | 1166474 | |
| J | 1166195 | |
| c | 1166041 | |
| o | 1166020 | |
| n | 1166020 | |
| k | 1166018 | |
| l | 329218 | 3.4% |
| C | 249411 | 2.6% |
| y | 248414 | 2.6% |
| Other values (15) | 326085 | 3.4% |
Common
| Value | Count | Frequency (%) |
| 2 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 9645361 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 1495463 | |
| s | 1166474 | |
| J | 1166195 | |
| c | 1166041 | |
| o | 1166020 | |
| n | 1166020 | |
| k | 1166018 | |
| l | 329218 | 3.4% |
| C | 249411 | 2.6% |
| y | 248414 | 2.6% |
| Other values (16) | 326087 | 3.4% |
COUNCIL DISTRICT
Real number (ℝ)
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 35242 |
| Missing (%) | 2.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.7171017 |
| Minimum | 1 |
|---|---|
| Maximum | 6 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 11.9 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 4 |
| Q3 | 5 |
| 95-th percentile | 6 |
| Maximum | 6 |
| Range | 5 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.5887064 |
|---|---|
| Coefficient of variation (CV) | 0.42740462 |
| Kurtosis | -0.99747228 |
| Mean | 3.7171017 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | -0.19876216 |
| Sum | 5679631 |
| Variance | 2.5239881 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 3 | 365648 | |
| 5 | 313864 | |
| 4 | 269603 | |
| 6 | 243506 | |
| 1 | 196785 | |
| 2 | 138567 | 8.9% |
| (Missing) | 35242 | 2.3% |
| Value | Count | Frequency (%) |
| 1 | 196785 | |
| 2 | 138567 | 8.9% |
| 3 | 365648 | |
| 4 | 269603 | |
| 5 | 313864 | |
| 6 | 243506 |
| Value | Count | Frequency (%) |
| 6 | 243506 | |
| 5 | 313864 | |
| 4 | 269603 | |
| 3 | 365648 | |
| 2 | 138567 | 8.9% |
| 1 | 196785 |
POLICE DISTRICT
Categorical
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 35265 |
| Missing (%) | 2.3% |
| Memory size | 11.9 MiB |
| Metro | |
|---|---|
| East | |
| Central | |
| Shoal Creek | |
| South |
Length
| Max length | 11 |
|---|---|
| Median length | 7 |
| Mean length | 5.8854269 |
| Min length | 4 |
Characters and Unicode
| Total characters | 8992638 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Metro |
|---|---|
| 2nd row | Shoal Creek |
| 3rd row | East |
| 4th row | East |
| 5th row | Central |
Common Values
| Value | Count | Frequency (%) |
| Metro | 383130 | |
| East | 374326 | |
| Central | 234327 | |
| Shoal Creek | 209760 | |
| South | 201792 | |
| North | 124615 | 8.0% |
| (Missing) | 35265 | 2.3% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| metro | 383130 | |
| east | 374326 | |
| central | 234327 | |
| shoal | 209760 | |
| creek | 209760 | |
| south | 201792 | |
| north | 124615 | 7.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| t | 1318190 | |
| e | 1036977 | |
| r | 951832 | |
| o | 919297 | |
| a | 818413 | |
| h | 536167 | 6.0% |
| C | 444087 | 4.9% |
| l | 444087 | 4.9% |
| S | 411552 | 4.6% |
| M | 383130 | 4.3% |
| Other values (7) | 1728906 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 7045168 | |
| Uppercase Letter | 1737710 | 19.3% |
| Space Separator | 209760 | 2.3% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| t | 1318190 | |
| e | 1036977 | |
| r | 951832 | |
| o | 919297 | |
| a | 818413 | |
| h | 536167 | |
| l | 444087 | 6.3% |
| s | 374326 | 5.3% |
| n | 234327 | 3.3% |
| k | 209760 | 3.0% |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 444087 | |
| S | 411552 | |
| M | 383130 | |
| E | 374326 | |
| N | 124615 | 7.2% |
Space Separator
| Value | Count | Frequency (%) |
| 209760 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 8782878 | |
| Common | 209760 | 2.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| t | 1318190 | |
| e | 1036977 | |
| r | 951832 | |
| o | 919297 | |
| a | 818413 | |
| h | 536167 | 6.1% |
| C | 444087 | 5.1% |
| l | 444087 | 5.1% |
| S | 411552 | 4.7% |
| M | 383130 | 4.4% |
| Other values (6) | 1519146 |
Common
| Value | Count | Frequency (%) |
| 209760 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 8992638 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| t | 1318190 | |
| e | 1036977 | |
| r | 951832 | |
| o | 919297 | |
| a | 818413 | |
| h | 536167 | 6.0% |
| C | 444087 | 4.9% |
| l | 444087 | 4.9% |
| S | 411552 | 4.6% |
| M | 383130 | 4.3% |
| Other values (7) | 1728906 |
PARCEL ID NO
Real number (ℝ)
SKEWED  ZEROS 
| Distinct | 175953 |
|---|---|
| Distinct (%) | 11.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 106754.49 |
| Minimum | 0 |
|---|---|
| Maximum | 9.9589235 × 108 |
| Zeros | 35266 |
| Zeros (%) | 2.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 11.9 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 3898 |
| Q1 | 38358 |
| median | 85391 |
| Q3 | 136854 |
| 95-th percentile | 228308 |
| Maximum | 9.9589235 × 108 |
| Range | 9.9589235 × 108 |
| Interquartile range (IQR) | 98496 |
Descriptive statistics
| Standard deviation | 2353178.5 |
|---|---|
| Coefficient of variation (CV) | 22.042899 |
| Kurtosis | 76590.509 |
| Mean | 106754.49 |
| Median Absolute Deviation (MAD) | 49221 |
| Skewness | 250.90887 |
| Sum | 1.6688022 × 1011 |
| Variance | 5.5374489 × 1012 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 35266 | 2.3% |
| 12614 | 4942 | 0.3% |
| 492 | 2754 | 0.2% |
| 12926 | 1265 | 0.1% |
| 128568 | 542 | < 0.1% |
| 99048 | 520 | < 0.1% |
| 98624 | 450 | < 0.1% |
| 142693 | 433 | < 0.1% |
| 12635 | 414 | < 0.1% |
| 127254 | 360 | < 0.1% |
| Other values (175943) | 1516269 |
| Value | Count | Frequency (%) |
| 0 | 35266 | |
| 1 | 28 | < 0.1% |
| 5 | 13 | < 0.1% |
| 6 | 1 | < 0.1% |
| 7 | 142 | < 0.1% |
| 10 | 30 | < 0.1% |
| 12 | 23 | < 0.1% |
| 14 | 3 | < 0.1% |
| 17 | 72 | < 0.1% |
| 18 | 42 | < 0.1% |
| Value | Count | Frequency (%) |
| 995892354 | 1 | < 0.1% |
| 935159351 | 1 | < 0.1% |
| 675192432 | 4 | |
| 673306734 | 1 | < 0.1% |
| 672126721 | 1 | < 0.1% |
| 647706478 | 1 | < 0.1% |
| 647476476 | 1 | < 0.1% |
| 620486201 | 1 | < 0.1% |
| 485674857 | 1 | < 0.1% |
| 250613250 | 3 |
LATITUDE
Real number (ℝ)
| Distinct | 157747 |
|---|---|
| Distinct (%) | 10.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 38.985272 |
| Minimum | 35.797519 |
|---|---|
| Maximum | 39.35464 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 11.9 MiB |
Quantile statistics
| Minimum | 35.797519 |
|---|---|
| 5-th percentile | 38.915251 |
| Q1 | 38.997002 |
| median | 39.054552 |
| Q3 | 39.109302 |
| 95-th percentile | 39.257015 |
| Maximum | 39.35464 |
| Range | 3.557121 |
| Interquartile range (IQR) | 0.1123 |
Descriptive statistics
| Standard deviation | 0.52951741 |
|---|---|
| Coefficient of variation (CV) | 0.013582499 |
| Kurtosis | 31.132856 |
| Mean | 38.985272 |
| Median Absolute Deviation (MAD) | 0.056051 |
| Skewness | -5.6446435 |
| Sum | 60942361 |
| Variance | 0.28038868 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 35.797519 | 40610 | 2.6% |
| 39.100387 | 4940 | 0.3% |
| 39.014493 | 2469 | 0.2% |
| 39.099123 | 1246 | 0.1% |
| 39.074934 | 476 | < 0.1% |
| 39.285963 | 380 | < 0.1% |
| 39.031378 | 374 | < 0.1% |
| 39.100349 | 371 | < 0.1% |
| 39.307933 | 360 | < 0.1% |
| 39.074825 | 312 | < 0.1% |
| Other values (157737) | 1511677 |
| Value | Count | Frequency (%) |
| 35.797519 | 40610 | |
| 38.827084 | 1 | < 0.1% |
| 38.83482 | 5 | < 0.1% |
| 38.835025 | 6 | < 0.1% |
| 38.838219 | 29 | < 0.1% |
| 38.838324 | 5 | < 0.1% |
| 38.838331 | 34 | < 0.1% |
| 38.838343 | 3 | < 0.1% |
| 38.838587 | 8 | < 0.1% |
| 38.838841 | 4 | < 0.1% |
| Value | Count | Frequency (%) |
| 39.35464 | 5 | < 0.1% |
| 39.354635 | 2 | < 0.1% |
| 39.354631 | 1 | < 0.1% |
| 39.354629 | 6 | < 0.1% |
| 39.354601 | 3 | < 0.1% |
| 39.354591 | 5 | < 0.1% |
| 39.354575 | 16 | |
| 39.353859 | 1 | < 0.1% |
| 39.353853 | 3 | < 0.1% |
| 39.353638 | 1 | < 0.1% |
LONGITUDE
Real number (ℝ)
| Distinct | 126281 |
|---|---|
| Distinct (%) | 8.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -94.792875 |
| Minimum | -103.89058 |
|---|---|
| Maximum | -94.386375 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 1563215 |
| Negative (%) | 100.0% |
| Memory size | 11.9 MiB |
Quantile statistics
| Minimum | -103.89058 |
|---|---|
| 5-th percentile | -94.645131 |
| Q1 | -94.583575 |
| median | -94.55375 |
| Q3 | -94.523262 |
| 95-th percentile | -94.474424 |
| Maximum | -94.386375 |
| Range | 9.504204 |
| Interquartile range (IQR) | 0.060313 |
Descriptive statistics
| Standard deviation | 1.4864643 |
|---|---|
| Coefficient of variation (CV) | -0.015681181 |
| Kurtosis | 33.45319 |
| Mean | -94.792875 |
| Median Absolute Deviation (MAD) | 0.030071 |
| Skewness | -5.9512036 |
| Sum | -1.4818164 × 108 |
| Variance | 2.209576 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| -103.890579 | 40610 | 2.6% |
| -94.577919 | 4958 | 0.3% |
| -94.529933 | 2472 | 0.2% |
| -94.577983 | 1246 | 0.1% |
| -94.591904 | 481 | < 0.1% |
| -94.576776 | 414 | < 0.1% |
| -94.472954 | 378 | < 0.1% |
| -94.540878 | 372 | < 0.1% |
| -94.59448 | 370 | < 0.1% |
| -94.588552 | 320 | < 0.1% |
| Other values (126271) | 1511594 |
| Value | Count | Frequency (%) |
| -103.890579 | 40610 | |
| -94.756681 | 1 | < 0.1% |
| -94.756298 | 1 | < 0.1% |
| -94.754146 | 1 | < 0.1% |
| -94.752204 | 1 | < 0.1% |
| -94.752202 | 1 | < 0.1% |
| -94.752171 | 12 | < 0.1% |
| -94.75217 | 2 | < 0.1% |
| -94.752163 | 8 | < 0.1% |
| -94.752122 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| -94.386375 | 26 | |
| -94.386377 | 2 | < 0.1% |
| -94.386465 | 1 | < 0.1% |
| -94.386516 | 13 | |
| -94.386648 | 12 | |
| -94.386673 | 1 | < 0.1% |
| -94.386677 | 8 | < 0.1% |
| -94.386711 | 3 | < 0.1% |
| -94.386814 | 2 | < 0.1% |
| -94.386906 | 2 | < 0.1% |
CASE URL
Categorical
HIGH CARDINALITY  UNIFORM  UNIQUE 
| Distinct | 1563215 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 11.9 MiB |
| http://city.kcmo.org/kc/ActionCenterRequest/CaseInfo.aspx?CaseID=2019119972 | 1 |
|---|---|
| http://city.kcmo.org/kc/ActionCenterRequest/CaseInfo.aspx?CaseID=2015045877 | 1 |
| http://city.kcmo.org/kc/ActionCenterRequest/CaseInfo.aspx?CaseID=2015040302 | 1 |
| http://city.kcmo.org/kc/ActionCenterRequest/CaseInfo.aspx?CaseID=2015041682 | 1 |
| http://city.kcmo.org/kc/ActionCenterRequest/CaseInfo.aspx?CaseID=2015049038 | 1 |
| Other values (1563210) |
Length
| Max length | 91 |
|---|---|
| Median length | 75 |
| Mean length | 75.007103 |
| Min length | 75 |
Characters and Unicode
| Total characters | 117252229 |
|---|---|
| Distinct characters | 43 |
| Distinct categories | 5 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1563215 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | http://city.kcmo.org/kc/ActionCenterRequest/CaseInfo.aspx?CaseID=2019119972 |
|---|---|
| 2nd row | http://city.kcmo.org/kc/ActionCenterRequest/CaseInfo.aspx?CaseID=2019207923 |
| 3rd row | http://city.kcmo.org/kc/ActionCenterRequest/CaseInfo.aspx?CaseID=2021005976 |
| 4th row | http://city.kcmo.org/kc/ActionCenterRequest/CaseInfo.aspx?CaseID=2020149407 |
| 5th row | http://city.kcmo.org/kc/ActionCenterRequest/CaseInfo.aspx?CaseID=2020054721 |
Common Values
| Value | Count | Frequency (%) |
| http://city.kcmo.org/kc/ActionCenterRequest/CaseInfo.aspx?CaseID=2019119972 | 1 | < 0.1% |
| http://city.kcmo.org/kc/ActionCenterRequest/CaseInfo.aspx?CaseID=2015045877 | 1 | < 0.1% |
| http://city.kcmo.org/kc/ActionCenterRequest/CaseInfo.aspx?CaseID=2015040302 | 1 | < 0.1% |
| http://city.kcmo.org/kc/ActionCenterRequest/CaseInfo.aspx?CaseID=2015041682 | 1 | < 0.1% |
| http://city.kcmo.org/kc/ActionCenterRequest/CaseInfo.aspx?CaseID=2015049038 | 1 | < 0.1% |
| http://city.kcmo.org/kc/ActionCenterRequest/CaseInfo.aspx?CaseID=2015034811 | 1 | < 0.1% |
| http://city.kcmo.org/kc/ActionCenterRequest/CaseInfo.aspx?CaseID=2015041579 | 1 | < 0.1% |
| http://city.kcmo.org/kc/ActionCenterRequest/CaseInfo.aspx?CaseID=2015042453 | 1 | < 0.1% |
| http://city.kcmo.org/kc/ActionCenterRequest/CaseInfo.aspx?CaseID=2015052481 | 1 | < 0.1% |
| http://city.kcmo.org/kc/ActionCenterRequest/CaseInfo.aspx?CaseID=2015043953 | 1 | < 0.1% |
| Other values (1563205) | 1563205 |
Length
| Value | Count | Frequency (%) |
| http://city.kcmo.org/kc/actioncenterrequest/caseinfo.aspx?caseid=2019119972 | 1 | < 0.1% |
| http://city.kcmo.org/kc/actioncenterrequest/caseinfo.aspx?caseid=2019208975 | 1 | < 0.1% |
| http://city.kcmo.org/kc/actioncenterrequest/caseinfo.aspx?caseid=2020054721 | 1 | < 0.1% |
| http://city.kcmo.org/kc/actioncenterrequest/caseinfo.aspx?caseid=2019182182 | 1 | < 0.1% |
| http://city.kcmo.org/kc/actioncenterrequest/caseinfo.aspx?caseid=2019184705 | 1 | < 0.1% |
| http://city.kcmo.org/kc/actioncenterrequest/caseinfo.aspx?caseid=2019184590 | 1 | < 0.1% |
| http://city.kcmo.org/kc/actioncenterrequest/caseinfo.aspx?caseid=2020095175 | 1 | < 0.1% |
| http://city.kcmo.org/kc/actioncenterrequest/caseinfo.aspx?caseid=2015094486 | 1 | < 0.1% |
| http://city.kcmo.org/kc/actioncenterrequest/caseinfo.aspx?caseid=2020021142 | 1 | < 0.1% |
| http://city.kcmo.org/kc/actioncenterrequest/caseinfo.aspx?caseid=2020086645 | 1 | < 0.1% |
| Other values (1563205) | 1563205 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 9379984 | 8.0% |
| t | 9378596 | 8.0% |
| / | 7816075 | 6.7% |
| o | 6254942 | 5.3% |
| s | 6254248 | 5.3% |
| c | 6252860 | 5.3% |
| n | 4691033 | 4.0% |
| a | 4689645 | 4.0% |
| . | 4689645 | 4.0% |
| C | 4689645 | 4.0% |
| Other values (33) | 53155556 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 71918994 | |
| Other Punctuation | 15632150 | 13.3% |
| Decimal Number | 15632150 | 13.3% |
| Uppercase Letter | 12505720 | 10.7% |
| Math Symbol | 1563215 | 1.3% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 9379984 | |
| t | 9378596 | |
| o | 6254942 | |
| s | 6254248 | 8.7% |
| c | 6252860 | 8.7% |
| n | 4691033 | 6.5% |
| a | 4689645 | 6.5% |
| p | 3127124 | 4.3% |
| i | 3127124 | 4.3% |
| r | 3126430 | 4.3% |
| Other values (13) | 15637008 |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 3757171 | |
| 2 | 2729759 | |
| 1 | 2605774 | |
| 9 | 1022088 | 6.5% |
| 8 | 999282 | 6.4% |
| 3 | 946917 | 6.1% |
| 7 | 941128 | 6.0% |
| 5 | 883944 | 5.7% |
| 4 | 881469 | 5.6% |
| 6 | 864618 | 5.5% |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 4689645 | |
| I | 3126430 | |
| D | 1563215 | 12.5% |
| R | 1563215 | 12.5% |
| A | 1563215 | 12.5% |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 7816075 | |
| . | 4689645 | |
| ? | 1563215 | 10.0% |
| : | 1563215 | 10.0% |
Math Symbol
| Value | Count | Frequency (%) |
| = | 1563215 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 84424714 | |
| Common | 32827515 | 28.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 9379984 | 11.1% |
| t | 9378596 | 11.1% |
| o | 6254942 | 7.4% |
| s | 6254248 | 7.4% |
| c | 6252860 | 7.4% |
| n | 4691033 | 5.6% |
| a | 4689645 | 5.6% |
| C | 4689645 | 5.6% |
| p | 3127124 | 3.7% |
| i | 3127124 | 3.7% |
| Other values (18) | 26579513 |
Common
| Value | Count | Frequency (%) |
| / | 7816075 | |
| . | 4689645 | |
| 0 | 3757171 | |
| 2 | 2729759 | 8.3% |
| 1 | 2605774 | 7.9% |
| = | 1563215 | 4.8% |
| ? | 1563215 | 4.8% |
| : | 1563215 | 4.8% |
| 9 | 1022088 | 3.1% |
| 8 | 999282 | 3.0% |
| Other values (5) | 4518076 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 117252229 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 9379984 | 8.0% |
| t | 9378596 | 8.0% |
| / | 7816075 | 6.7% |
| o | 6254942 | 5.3% |
| s | 6254248 | 5.3% |
| c | 6252860 | 5.3% |
| n | 4691033 | 4.0% |
| a | 4689645 | 4.0% |
| . | 4689645 | 4.0% |
| C | 4689645 | 4.0% |
| Other values (33) | 53155556 |
30-60-90 Days Open Window
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1550513 |
| Missing (%) | 99.2% |
| Memory size | 11.9 MiB |
| 0.0 | |
|---|---|
| 90.0 | |
| 30.0 | 415 |
| 60.0 | 302 |
Length
| Max length | 4 |
|---|---|
| Median length | 3 |
| Mean length | 3.4183593 |
| Min length | 3 |
Characters and Unicode
| Total characters | 43420 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 7388 | 0.5% |
| 90.0 | 4597 | 0.3% |
| 30.0 | 415 | < 0.1% |
| 60.0 | 302 | < 0.1% |
| (Missing) | 1550513 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 7388 | |
| 90.0 | 4597 | |
| 30.0 | 415 | 3.3% |
| 60.0 | 302 | 2.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 25404 | |
| . | 12702 | |
| 9 | 4597 | 10.6% |
| 3 | 415 | 1.0% |
| 6 | 302 | 0.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 30718 | |
| Other Punctuation | 12702 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 25404 | |
| 9 | 4597 | 15.0% |
| 3 | 415 | 1.4% |
| 6 | 302 | 1.0% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 12702 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 43420 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 25404 | |
| . | 12702 | |
| 9 | 4597 | 10.6% |
| 3 | 415 | 1.0% |
| 6 | 302 | 0.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 43420 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 25404 | |
| . | 12702 | |
| 9 | 4597 | 10.6% |
| 3 | 415 | 1.0% |
| 6 | 302 | 0.7% |
| CASE ID | SOURCE | DEPARTMENT | WORK GROUP | REQUEST TYPE | CATEGORY | TYPE | DETAIL | CREATION DATE | CREATION TIME | CREATION MONTH | CREATION YEAR | STATUS | EXCEEDED EST TIMEFRAME | CLOSED DATE | CLOSED MONTH | CLOSED YEAR | DAYS TO CLOSE | STREET ADDRESS | ADDRESS WITH GEOCODE | ZIP CODE | NEIGHBORHOOD | COUNTY | COUNCIL DISTRICT | POLICE DISTRICT | PARCEL ID NO | LATITUDE | LONGITUDE | CASE URL | 30-60-90 Days Open Window | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2019119972 | PHONE | NHS | NHS-Dangerous Buildings- | Prop/Build/Construct-Dangerous Building-On list | Property / Buildings / Construction | Dangerous Building | Standard | 06/24/2019 | 07:40 AM | 6 | 2019 | RESOL | Y | 11/19/2021 | 11.0 | 2021.0 | 879.0 | 2317 E 50th St | 2317 E 50th St64130\n(39.035489, -94.557309) | 64130.0 | Blue Hills | Jackson | 3.0 | Metro | 138863 | 39.035489 | -94.557309 | http://city.kcmo.org/kc/ActionCenterRequest/CaseInfo.aspx?CaseID=2019119972 | NaN |
| 1 | 2019207923 | WEB | Public Works | Public Works-Street and Traffic-District 1 | Streets / Roadways / Alleys-Crack-District 1 | Streets / Roadways / Alleys | Crack | District 1 | 12/22/2019 | 07:56 PM | 12 | 2019 | RESOL | Y | 06/26/2020 | 6.0 | 2020.0 | 187.0 | 10329 N Forest Ave | 10329 N Forest Ave64155\n(39.28196, -94.564453) | 64155.0 | New Mark | Clay | 2.0 | Shoal Creek | 103703 | 39.281960 | -94.564453 | http://city.kcmo.org/kc/ActionCenterRequest/CaseInfo.aspx?CaseID=2019207923 | NaN |
| 2 | 2021005976 | PHONE | NHS | NHS-Dangerous Buildings- | Prop/Build/Construct-Dangerous Building-On list | Property / Buildings / Construction | Dangerous Building | Standard | 01/19/2021 | 02:43 PM | 1 | 2021 | RESOL | Y | 11/15/2021 | 11.0 | 2021.0 | 300.0 | 2623 E 10th St | 2623 E 10th St64127\n(39.101272, -94.549951) | 64127.0 | Independence Plaza | Jackson | 3.0 | East | 10703 | 39.101272 | -94.549951 | http://city.kcmo.org/kc/ActionCenterRequest/CaseInfo.aspx?CaseID=2021005976 | NaN |
| 3 | 2020149407 | PHONE | NHS | NHS-Neighborhood Preservation- | Property Violations | Property / Buildings / Construction | Property Maintenance | Other Property Issue | 11/25/2020 | 09:19 AM | 11 | 2020 | RESOL | Y | 04/26/2021 | 4.0 | 2021.0 | 152.0 | 2474 Chelsea Ave | 2474 Chelsea Ave64127\n(39.079895, -94.526959) | 64127.0 | East Community Team South | Jackson | 3.0 | East | 19178 | 39.079895 | -94.526959 | http://city.kcmo.org/kc/ActionCenterRequest/CaseInfo.aspx?CaseID=2020149407 | NaN |
| 4 | 2020054721 | WEB | Parks and Rec | Parks and Rec-Central Region- | Parks & Recreation-Park Maintenance-Central | Parks & Recreation | Park Maintenance | Central | 04/18/2020 | 05:10 PM | 4 | 2020 | RESOL | N | 04/30/2020 | 4.0 | 2020.0 | 12.0 | 400 W 31st St | 400 W 31st St64108\n(39.074934, -94.591904) | 64108.0 | Westside South | Jackson | 4.0 | Central | 128568 | 39.074934 | -94.591904 | http://city.kcmo.org/kc/ActionCenterRequest/CaseInfo.aspx?CaseID=2020054721 | NaN |
| 5 | 2019182182 | PHONE | NHS | NHS-Dangerous Buildings- | Prop/Build/Construct-Dangerous Building-On list | Property / Buildings / Construction | Dangerous Building | Standard | 10/21/2019 | 10:29 AM | 10 | 2019 | RESOL | Y | 08/03/2020 | 8.0 | 2020.0 | 287.0 | 4043 Kenwood Ave | 4043 Kenwood Ave64110\n(39.052983, -94.577808) | 64110.0 | South Hyde Park | Jackson | 4.0 | Central | 133291 | 39.052983 | -94.577808 | http://city.kcmo.org/kc/ActionCenterRequest/CaseInfo.aspx?CaseID=2019182182 | NaN |
| 6 | 2019184705 | WEB | NHS | NHS-Solid Waste- | Trash / Recycling-Recycling-Missed by City | Trash / Recycling | Recycling | Missed by City | 10/25/2019 | 10:02 AM | 10 | 2019 | RESOL | N | 10/28/2019 | 10.0 | 2019.0 | 3.0 | 637 E 62nd St | 637 E 62nd St64110\n(39.01416, -94.579673) | 64110.0 | Western 49-63 | Jackson | 6.0 | Metro | 106106 | 39.014160 | -94.579673 | http://city.kcmo.org/kc/ActionCenterRequest/CaseInfo.aspx?CaseID=2019184705 | NaN |
| 7 | 2019184590 | WEB | Parks and Rec | Parks and Rec-Landscape Services-Forestry | Trees-Trimming-Tree Limbs | Trees | Trimming | Tree Limbs | 10/25/2019 | 04:44 AM | 10 | 2019 | RESOL | Y | 12/04/2019 | 12.0 | 2019.0 | 40.0 | 10901 Blue Ridge Blvd | 10901 Blue Ridge Blvd64134\n(38.924085, -94.507192) | 64134.0 | Ruskin Heights | Jackson | 6.0 | South | 59546 | 38.924085 | -94.507192 | http://city.kcmo.org/kc/ActionCenterRequest/CaseInfo.aspx?CaseID=2019184590 | NaN |
| 8 | 2020095175 | PHONE | NHS | NHS-Dangerous Buildings- | Prop/Build/Construct-Dangerous Building-On list | Property / Buildings / Construction | Dangerous Building | Standard | 07/13/2020 | 08:00 AM | 7 | 2020 | RESOL | Y | 11/29/2021 | 11.0 | 2021.0 | 504.0 | 4215 E 60th St | 4215 E 60th St64130\n(39.016565, -94.536611) | 64130.0 | Swope Parkway-Elmwood | Jackson | 5.0 | Metro | 326 | 39.016565 | -94.536611 | http://city.kcmo.org/kc/ActionCenterRequest/CaseInfo.aspx?CaseID=2020095175 | NaN |
| 9 | 2015094486 | PHONE | NHS | NHS-Solid Waste-Administration | Trash / Recycling-Services-Service Issue / Problem | Trash / Recycling | Services | Service Issue / Problem | 08/07/2015 | 01:45 PM | 8 | 2015 | RESOL | Y | 05/27/2016 | 5.0 | 2016.0 | 294.0 | 4518 N Askew Ave | 4518 N Askew Ave64117\n(39.176846, -94.537416) | 64117.0 | Antioch Acres | Clay | 1.0 | Shoal Creek | 76946 | 39.176846 | -94.537416 | http://city.kcmo.org/kc/ActionCenterRequest/CaseInfo.aspx?CaseID=2015094486 | NaN |
| CASE ID | SOURCE | DEPARTMENT | WORK GROUP | REQUEST TYPE | CATEGORY | TYPE | DETAIL | CREATION DATE | CREATION TIME | CREATION MONTH | CREATION YEAR | STATUS | EXCEEDED EST TIMEFRAME | CLOSED DATE | CLOSED MONTH | CLOSED YEAR | DAYS TO CLOSE | STREET ADDRESS | ADDRESS WITH GEOCODE | ZIP CODE | NEIGHBORHOOD | COUNTY | COUNCIL DISTRICT | POLICE DISTRICT | PARCEL ID NO | LATITUDE | LONGITUDE | CASE URL | 30-60-90 Days Open Window | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1563205 | 2019175846 | PHONE | Parks and Rec | Parks and Rec-Landscape Services-Forestry | Trees-Removal-Declining | Trees | Removal | Declining | 10/04/2019 | 11:35 AM | 10 | 2019 | RESOL | Y | 12/04/2019 | 12.0 | 2019.0 | 61.0 | 3942 Wyandotte St | 3942 Wyandotte St64111\n(39.055001, -94.588843) | 64111.0 | Old Westport | Jackson | 4.0 | Central | 132644 | 39.055001 | -94.588843 | http://city.kcmo.org/kc/ActionCenterRequest/CaseInfo.aspx?CaseID=2019175846 | NaN |
| 1563206 | 2019175727 | PHONE | Parks and Rec | Parks and Rec-Landscape Services-Forestry | Trees-Removal-Tree Limbs | Trees | Removal | Tree Limbs | 10/04/2019 | 09:32 AM | 10 | 2019 | RESOL | Y | 11/05/2019 | 11.0 | 2019.0 | 32.0 | 9014 E 88th Ter | 9014 E 88th Ter64138\n(38.962712, -94.478245) | 64138.0 | White Oak | Jackson | 5.0 | South | 66408 | 38.962712 | -94.478245 | http://city.kcmo.org/kc/ActionCenterRequest/CaseInfo.aspx?CaseID=2019175727 | NaN |
| 1563207 | 2019176019 | PHONE | Parks and Rec | Parks and Rec-Landscape Services-Forestry | Trees-Trimming-Block Pruning | Trees | Trimming | Block Pruning | 10/04/2019 | 03:51 PM | 10 | 2019 | RESOL | N | 10/11/2019 | 10.0 | 2019.0 | 7.0 | 9208 NE 109th Ct | 9208 NE 109th Ct64157\n(39.289643, -94.46439) | 64157.0 | Shoal Creek | Clay | 1.0 | Shoal Creek | 209678 | 39.289643 | -94.464390 | http://city.kcmo.org/kc/ActionCenterRequest/CaseInfo.aspx?CaseID=2019176019 | NaN |
| 1563208 | 2019175967 | PHONE | Parks and Rec | Parks and Rec-Landscape Services-Forestry | Trees-Trimming-Tree Limbs | Trees | Trimming | Tree Limbs | 10/04/2019 | 02:46 PM | 10 | 2019 | RESOL | Y | 10/30/2019 | 10.0 | 2019.0 | 26.0 | 3106 Peery Ave | 3106 Peery Ave64127\n(39.099803, -94.545545) | 64127.0 | Independence Plaza | Jackson | 3.0 | East | 10876 | 39.099803 | -94.545545 | http://city.kcmo.org/kc/ActionCenterRequest/CaseInfo.aspx?CaseID=2019175967 | NaN |
| 1563209 | 2019175920 | PHONE | Parks and Rec | Parks and Rec-Landscape Services-Forestry | Trees-Trimming-Tree Limbs | Trees | Trimming | Tree Limbs | 10/04/2019 | 01:04 PM | 10 | 2019 | RESOL | Y | 10/19/2019 | 10.0 | 2019.0 | 15.0 | 5048 NE 56th Pl | 5048 NE 56th Pl64119\n(39.195871, -94.518434) | 64119.0 | Ravenwood-Somerset | Clay | 1.0 | Shoal Creek | 90408 | 39.195871 | -94.518434 | http://city.kcmo.org/kc/ActionCenterRequest/CaseInfo.aspx?CaseID=2019175920 | NaN |
| 1563210 | 2019175624 | PHONE | NHS | NHS-Solid Waste- | Trash / Recycling-Trash Collection-Missed by Contractor North | Trash / Recycling | Trash Collection | Missed by Contractor North | 10/03/2019 | 06:18 PM | 10 | 2019 | RESOL | N | 10/05/2019 | 10.0 | 2019.0 | 2.0 | 10415 NW 87th St | 10415 NW 87th St64153\n(39.251356, -94.702155) | 64153.0 | KCI & 2nd Creek | Platte | 2.0 | North | 211724 | 39.251356 | -94.702155 | http://city.kcmo.org/kc/ActionCenterRequest/CaseInfo.aspx?CaseID=2019175624 | NaN |
| 1563211 | 2019176099 | PHONE | Parks and Rec | Parks and Rec-Central Region- | Parks & Recreation-Park Maintenance-Central | Parks & Recreation | Park Maintenance | Central | 10/05/2019 | 08:13 AM | 10 | 2019 | RESOL | N | 10/10/2019 | 10.0 | 2019.0 | 5.0 | 2308 Topping Ave | 2308 Topping Ave64127\n(39.082634, -94.515668) | 64127.0 | South Blue Valley | Jackson | 3.0 | East | 20118 | 39.082634 | -94.515668 | http://city.kcmo.org/kc/ActionCenterRequest/CaseInfo.aspx?CaseID=2019176099 | NaN |
| 1563212 | 2019176030 | PHONE | NHS | NHS-Solid Waste- | Animals / Pets-Dead Animal -Curb | Animals / Pets | Dead Animal | Curb | 10/04/2019 | 04:07 PM | 10 | 2019 | RESOL | N | 10/05/2019 | 10.0 | 2019.0 | 1.0 | 5437 South Benton Ave | 5437 South Benton Ave64130\n(39.026897, -94.551349) | 64130.0 | North Town Fork Creek | Jackson | 5.0 | Metro | 36265 | 39.026897 | -94.551349 | http://city.kcmo.org/kc/ActionCenterRequest/CaseInfo.aspx?CaseID=2019176030 | NaN |
| 1563213 | 2019176115 | PHONE | Public Works | Public Works-Capital Projects-Traffic Permits | Streets / Roadways / Alleys-Plate-Missing / Displaced | Streets / Roadways / Alleys | Plate | Missing / Displaced | 10/05/2019 | 04:50 PM | 10 | 2019 | RESOL | Y | 12/04/2019 | 12.0 | 2019.0 | 60.0 | 1201 W 75th St | 1201 W 75th St64114\n(38.992568, -94.604029) | 64114.0 | Ward Parkway | Jackson | 6.0 | Metro | 120444 | 38.992568 | -94.604029 | http://city.kcmo.org/kc/ActionCenterRequest/CaseInfo.aspx?CaseID=2019176115 | NaN |
| 1563214 | 2019172858 | WEB | City Planning and Development | City Planning and Development-Permit Compliance- | Prop/Build/Construct-Construction Issue/Concern-Work without permit | Property / Buildings / Construction | Construction Issue/Concern | Work Without Permit | 09/27/2019 | 08:01 PM | 9 | 2019 | RESOL | Y | 10/06/2019 | 10.0 | 2019.0 | 9.0 | 10799 NW Skyview Ave | 10799 NW Skyview Ave64154\n(39.288525, -94.651254) | 64154.0 | KCI & 2nd Creek | Platte | 2.0 | North | 207756 | 39.288525 | -94.651254 | http://city.kcmo.org/kc/ActionCenterRequest/CaseInfo.aspx?CaseID=2019172858 | NaN |